Re: help! DATE problem

Is the "creation_date" field in "date" datatype? If not, you may try the to_date function on "creation_date". Also, couldn't you just use:

SELECT creation_date FROM my_table WHERE creation_date < '02-JAN-99'

to get the desired result?  

kal121_at_yahoo.com wrote:
: I have a query that goes like this:

: for example:
: SELECT creation_date FROM my_table WHERE creation_date <= '01-JAN-99';

: Problem is, I've got data in my_table that looks like this:

: 01-JAN-99 09:34:30
: 01-JAN-99 11:10:24
: 01-JAN-99 11:15:43

: So effectively, when I run this query, it WILL NOT select the above dates
: since those dates are not before 01-JAN-99 00:00:00 - which is what is being
: specified in the above query.

: I've tried to manipulate the date with the TO_DATE function:
: for example:
: select * from my_table where creation_date <= to_date('09-03-99 01:52:30',
: 'DD-MM-YY HR24:MI:SS') This does not work.

: Does anybody know how to make this work?

: Thanks much

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Mar 08 1999 - 17:17:28 CST