Re: Trouble selecting dates

"Nigel Reed" <nelgin_at_nortelnutworks.com> wrote in message news:34kraugstdroe4r9qpmp78k041sobrrpkr_at_4ax.com...
> I've been dumped a project and not really an Oracle type, so I hope
> someone can help me with this issue.
>
> SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH:MI:SS';
>
> Session altered.
>
> SQL> select request_date from new_absencehistory where
> absence_type='PH';
>
> REQUEST_DATE
> -------------------
> 2002-03-13 03:12:55
> 2002-03-13 03:19:39
>
> SQL> select request_date from new_absencehistory where
> request_date=to_date('2002-03-13 03:19:39','YYYY-MM-DD HH:MI:SS');
>
> no rows selected
>
> Now my question is, why can't I select on this date?
>
> Any advice would be appreciated cos I'm stuck.
>
> 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 *

One might be AM and the other one PM. Try changing the mask from HH to HH24 and see what happens.

Hth

--
Sybrand Bakker
Senior Oracle DBA

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