SQLPlus date formatting ?

-----BEGIN PGP SIGNED MESSAGE-----
I have the following line in an SQL script file:

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

It is from some sample code in one of the Intergraph Oracle documents. The problem is that the time "03:01" will show up as "3:1"; all leading zeros are lost. Is there a way to adjust my format string to get those missing zeros?

Thanks...

• -- Roger Walker (403) 465-4962 **** SysOp, CUE Here BBS (403) 465-7715 GIS Analyst (403) 496-4145 FAX (403) 496-4014 Roger_Walker_at_CUEHere.Edmonton.AB.CA

    PGP Public Key from: Roger_Walker_PGP_at_CUEHere.Edmonton.AB.CA

-----BEGIN PGP SIGNATURE-----

Version: 2.3a.2

iQCVAgUBLhiB2D/v28X+fuhhAQHQLwP/WXUhsGsbmlcYYQdJYx+qsFMwRmDXBuxZ 1XcfEYUZIWeUPipGkIbVA+JqPLJ9ve321cWL+vy3aWLau9OrMWYtShjrqo43ovPv UmEXB1uhxLVcfbtVlmj7iI92gr2tB/bDOMtosdM127O8jMSHKlC3qTVQ5KnoyC7o IjV9POqLiNo=
=qgZ1
-----END PGP SIGNATURE-----
Received on Mon Jul 04 1994 - 23:41:03 CEST