Simple "Where date less than today" query 1

[JohnOB]

I want to write a simple query but am just a learner, and am struggling with what I think is the curdate function.

I want to return values where a date field is less then todays date

I currently have

select * from TABLE where vacated_date <= curdate

but it is not working.

This field is a datetime field.

Thanks

"Stupid isn't not knowing the answer, it's not asking the question

 

[dhulbert]

use getdate() instead of curdate

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[SQLHacker]

Also, if you don't want to include today, you need to remove the "=". In your post you mention that you want less than today's date. So, the syntax should be:

"SELECT * FROM Table WHERE vacated_date < getdate()

 

[ca8msm]

Also, if you don't want to include today, you need to remove the "=". In your post you mention that you want less than today's date. So, the syntax should be:

"SELECT * FROM Table WHERE vacated_date < getdate()"

That may still include records from today as the GetDate() function will return the current time as well.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.