Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Trouble selecting dates

Trouble selecting dates

From: Nigel Reed <nelgin_at_nortelnutworks.com>
Date: Fri, 05 Apr 2002 10:32:34 -0600
Message-ID: <34kraugstdroe4r9qpmp78k041sobrrpkr@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

Received on Fri Apr 05 2002 - 10:32:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US