Link to home
Start Free TrialLog in
Avatar of Becky Edwards
Becky EdwardsFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Rajkumar Gs
Rajkumar Gs
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Another way
select * from ORDER_PROC 
where DATEDIFF(minute ,  '09/01/2011', ORDERING_DATE) > 0

Open in new window

convert to datetime

select * from ORDER_PROC where ORDERING_DATE is > than convert(datetime,'2010-09-01')

Open in new window

Avatar of Becky Edwards

ASKER

Thank You!  That worked perfectly.
My pleasure!