RE: FN-FORUM: SQL less than or equal to operator problem

date posted 14th January 2007 23:55

When dealing with dates in SQL it is important to remember that SQL assumes
that you mean midnight. So between 13/01/2007 and 13/01/2007 assumes you
mean 00h 00m 00s 000ms (or midnight) and would return no records unless one
was created at that very moment.

When searching for records you should always pick the date before/after. Eg
to find records on the 13/01/2007 search between 13/01/2007 and 14/01/2007.
This will find all records created on 13/01/2007 between the times of
00:00:00:000 and 14/01/2007 at 00:00:00:000.

Aidan

-----Original Message-----
From: Paul Cooper [EMAIL REMOVED]
Sent: 13 January 2007 14:35
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: SQL less than or equal to operator problem


Hi

I've come across an issue to seems rather odd. I have a record in a
table that has a date field with the value of 13/01/2007 (today). The
field is called Generated date.

When I do this the record is not found:

WHERE GeneratedDate >= ' 13/01/2007 ' AND GeneratedDate = ' 13/01/2007 ' AND GeneratedDate = ' 12/01/2007 ' AND GeneratedDate