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

2007-02-03 Thread Shelby Cain
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 MS') from dual; SELECT to_char(timestamp '1970-01-01 00:00:00 GMT','J MS') from dual * ERROR at line 1: ORA-01821:

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

2007-02-03 Thread Bruce Momjian
Since to_char() is supposed to be Oracle-compatible, would someone test this query in Oracle? --- David Lee Lambert wrote: > Postgres version: 8.0.6 > Operating system: Ubuntu GNU/Linux > > I executed the following query