Selecting records before a certain date

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Selecting records before a certain date

Author

Topic

Lorna70
Starting Member

19 Posts

Posted - 2010-05-25 : 05:46:09

Hi I have a field in one of my tables which has a smalldatetime datatype and this has been causing me problems in creating a select statement to select all records before 30/10/2010.

I have tried all sorts of statements trying CAST, CONVERT and FLOOR to no avail!

The last one I tried was:

SELECT *
FROM tblLoads
WHERE JobDate < '30-10-2009 00:00:00'

Looking at dates in the table, they are displayed in this format (UK).
Any advice would be greatly appreciated :-)

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-05-25 : 05:48:28

Try:
WHERE JobDate < '20091030'

No, you're never too old to Yak'n'Roll if you're too young to die.