Oracle (9.2.0.7) doesn't seem to like the date format string...
SQL> SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J SSSS MS') from dual;
SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J SSSS MS') from dual
*
ERROR at line 1:
ORA-01821: date format not recognized
Regards,
Shelby Cain
----- Original Message ----
From: Bruce Momjian <[EMAIL PROTECTED]>
To: David Lee Lambert <[EMAIL PROTECTED]>
Cc: [email protected]
Sent: Saturday, February 3, 2007 5:56:00 PM
Subject: Re: [BUGS] "Julian day" date format is off by 12 hours
Since to_char() is supposed to be Oracle-compatible, would someone test
this query in Oracle?
>
> davidl=# SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J SSSS MS');
> to_char
> ---------------
> 2440588 0 000
> (1 row)
>
____________________________________________________________________________________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
