bug? to_char(DATE,'ddmmyyyy')=00000000 ???

From: Steve Edwards <edwards_at_>
Date: 1998/03/10
Message-ID: <6e4bu4$ehd$1@news2.infoave.net>#1/1

this query:

select to_char(observe_date,'mmddyyyy'),prcp from td3200_data where ucan_id = 17297 and observe_date > to_date('09011996','mmddyyyy') and observe_date < to_date('09301996','mmddyyyy')

gives this strange result:

TO_CHAR( PRCP
-------- ----------

00000000          0
00000000          9
00000000          0
00000000         14
00000000          1
00000000          0
00000000          1
00000000          3
00000000          0
00000000         24
00000000          0

TO_CHAR(       PRCP


-------- ----------

00000000          0
00000000          0
00000000          0
00000000          0
00000000         30
00000000          0
00000000          0
00000000          0
00000000          0
00000000         93
00000000          4

TO_CHAR(       PRCP


-------- ----------

00000000          0
00000000          0
00000000          0
00000000          0
00000000          0
00000000         24
00000000         19

Why is the date 00000000 ?

-- 
Steve A. Edwards, Programmer
Southeast Regional Climate Center 
SC Department of Natural Resources

Received on Tue Mar 10 1998 - 00:00:00 CST