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