Re: SQLPlus date formatting ?

From: Kim Ng <kimmng_at_uswnvg.com>
Date: 7 Jul 94 22:50:58 GMT
Message-ID: <32653_at_uswnvg.uswnvg.com>

: select to_char(sysdate, 'fmYY MON DD HH24:MI') today from dual;

                           ^^

Remove the "fm" and try again. It should preserve the zeros.

---

 Kim Ng
 (Just a low life contract programmer. Thus, my clients won't adopt my views.) Received on Fri Jul 08 1994 - 00:50:58 CEST