Hi,
Originally posted by Naadir Peterson:
but i need to select records of a certain date.. if i select only the date without the time it returns nothing...
to retrieve one date records through a dateTime column,
you should use BETWEEN clause:
(Examples using ISO format)
SELECT *
FROM table
WHERE the_date between '2004-10-09T00:00:00' and '2004-10-09T23:59:59'; (using ISO format)
or just
WHERE the_date between '2004-10-09' and '2004-10-10'
This will return all records from 10/9/04 00:00:00 thru 10/9/04 23:59:59 or thru 10/10/10 00:00:00. Both will almost be fine.
bob