strange date behaviour

From: Obakesan <cjundieseastwd_at_powerup.com.au>
Date: 2000/07/04
Message-ID: <8jrgpv$4u03_at_inetbws1.citec.com.au>#1/1

HiYa

[Quoted] how come the date component defaults to another date other than today when I do a to_date() and don't supply a year?

IE

SQL> select to_date('17:00 00','HH24:MI SS') from dual;

TO_DATE('

---

01-JUL-00 but when I look at the sysdate that I would have expeceted it to defalult to it's indeed correct.

SQL> select sysdate from dual;

SYSDATE

---

04-JUL-00 what am I missing??

thanks

--

See Ya
(when the bandwidth gets better ;-)
Chris Eastwood                            Please remove undies for reply
[Quoted] Photographer, Stunt Programmer            WWW -> www.powerup.com.au/~cjeastwd/
Motorcyclist and dingbat

Received on Tue Jul 04 2000 - 00:00:00 CEST