OrderDate is datetime type in order table. Date and time data is store in it like "2009-12-07 15:30:22.000"
How to complete the select statement without error as below? (I only need date part without time)
select * from order where format([OrderDate],"yyyy-mm-dd") = date.now.tostring("yyyy-mm-dd")
...
Go to the complete details ...