SQLPlus date formatting ?
Date: Mon, 4 Jul 94 15:41:03 MDT
Message-ID: <Roger_Walker.1g3f_at_CUEHere.Edmonton.AB.CA>
-----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?
- -- 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