Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Trouble selecting dates
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
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
![]() |
![]() |