Becky Edwards
asked on
How do I get data from a certain date range?
I wrote it like this but it errors out.
select * from ORDER_PROC where ORDERING_DATE is > than 2010-09-01
select * from ORDER_PROC where ORDERING_DATE is > than 2010-09-01
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
convert to datetime
select * from ORDER_PROC where ORDERING_DATE is > than convert(datetime,'2010-09-01')
ASKER
Thank You! That worked perfectly.
My pleasure!
Open in new window