TO_CHAR bug?

From: suvinay <suvinay_at_gmail.com>
Date: 21 Jul 2006 13:07:35 -0700
Message-ID: <1153512454.968662.250260@h48g2000cwc.googlegroups.com>

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-

---

2006-07-21T15:52:36.09

//--- 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

---

2006-07-21T15:07:29.14Z

Help appreciated very much.

Thanks.
-- Suvinay Received on Fri Jul 21 2006 - 15:07:35 CDT