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 d=
ual;
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@momjian.us>
To: David Lee Lambert <dlambert@bmtcarhaul.com>
Cc: pgsql-bugs@postgresql.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?
>=20
> davidl=3D# SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J SSSS MS'=
);
>     to_char
> ---------------
>  2440588 0 000
> (1 row)
>=20






=20
___________________________________________________________________________=
_________
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html