Re: TO_CHAR bug?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sat, 22 Jul 2006 07:19:11 +0200
Message-ID: <44c1b54d$0$30849$626a54ce@news.free.fr>

"suvinay" <suvinay_at_gmail.com> a écrit dans le message de news: 1153512454.968662.250260_at_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
|

Works for me:

SQL> select TO_CHAR(systimestamp, 'YYYY-MM-DD"T"HH24:MI:SS.FF2"Z"')   2 from dual;
TO_CHAR(SYSTIMESTAMP,'YYYY-MM-

---

2006-07-22T07:14:45.10Z

But of course a bug is neither related to a version nor to an environment.

Regards
Michel Cadot Received on Sat Jul 22 2006 - 00:19:11 CDT