Re: "Julian day" date format is off by 12 hours

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 <bruce(at)momjian(dot)us>
To: David Lee Lambert <dlambert(at)bmtcarhaul(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
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