Re: Trouble selecting dates - more

I had an email suggestion that I use HH24:MI:SS for my date format. I did try this with the same result. In the script that did the insert I had
$datefm="YYYY-MM-DD HH24:MI:SS";

So I know that it was inserted into the DB in that format...so I'm still stuck!

SQL> select request_date from new_absencehistory where request_date=to_date('2002-03-13 03:19:39','YYYY-MM-DD HH24:MI:SS');

no rows selected

Regards
Nigel

• When replying via email please change the nut to net ** -- Nigel Reed DES Engineering & Infrastructure Nortel Networks, 2201 Lakeside Blvd, Richardson, TX 75082 ESN 444 8859   External 972 684 8859                  Mailstop: 992/02/A30 We will never give Bill Clinton the opportunity to be the President of the United States. - Vice President Dan Quayle (9/19/92) * Any opinion expressed in this message is mine and not that of Nortel Networks *