Hey, I'm trying to run a SQL query but can't uncover any records when tiresome to select a certain date. Here's the query:
SELECT fld 1, fld 2, date,
FROM table 1
WHERE date = '01-SEP-2010'
I'm getting no results. The date field is formatted like this:
2010-SEP-02 10:01:04
Another query is:
SELECT fld 1, fld 2, date,
FROM table 1
WHERE date >= '01-SEP-2010' & date <= '01-DEC-2010'
I'm wonder that the trouble may have something to do with the date
field containing both the date.
Bookmarks