Avatar of MeowserM

asked on 

SQL Where Date and Time


I am working in a SQL database with a "OrderDate" field with the format 'YYYY-MM-DD 00:00:00'.

I am trying to write a SQL statement to get the records where the Order date is >= '2011-10-01'.

I am getting 0 records because I am not including the time but I have tried to include 00:00:00 and it hasn't worked.

What is the proper syntax to use for
WHERE OrderDate >= '2011-10-01'

Thank you
MySQL ServerMicrosoft SQL Server 2005SQL

Avatar of undefined
Last Comment

8/22/2022 - Mon