help! DATE problem

From: <kal121_at_yahoo.com>
Date: Mon, 08 Mar 1999 18:56:47 GMT
Message-ID: <7c16h9$hl7$1@nnrp1.dejanews.com>

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 - 12:56:47 CST