Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> TO_CHAR bug?
Hi,
In a few databases, the following statements results in a missing "Z"
at the end?
A bug?
SQL> select TO_CHAR(systimestamp, 'YYYY-MM-DD"T"HH24:MI:SS.FF2"Z"') from dual;
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-
//--- where is "Z" at the end?
If I give two space in "Z{space}{space}" as "Z ", it works
SQL> select TO_CHAR(systimestamp, 'YYYY-MM-DD"T"HH24:MI:SS.FF2"Z "') from dual;
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-DD
Help appreciated very much.
Thanks.
-- Suvinay
Received on Fri Jul 21 2006 - 15:07:35 CDT