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

• 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 *

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