Re: Trouble selecting dates - more

"Nigel Reed" <nelgin_at_nortelnutworks.com> wrote in message news:13oraug12oq850uq4cgcdl69ki79m0qhgo_at_4ax.com...
> 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 *

Somehow however the date column in your table is not what you expect it to be. You need to get that resolved.
Also: the column in the table is a proper date column? No implicit type conversion involved?

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address