Re: SQLPlus date formatting ?
From: Tommy Wareing <p0070621_at_oxford-brookes.ac.uk>
Date: Tue, 5 Jul 1994 08:37:36 GMT
Message-ID: <CsGLAo.4zs_at_uk.ac.brookes>
Date: Tue, 5 Jul 1994 08:37:36 GMT
Message-ID: <CsGLAo.4zs_at_uk.ac.brookes>
C U E Here Sysop (Roger_Walker_at_CUEHere.Edmonton.AB.CA) wrote:
> -----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?
RTFM. (Literally, Remove The FM).
-- _________________________ ________________________________ / Tommy Wareing \ / Dying ain't much of a living, \ | p0070621_at_brookes.ac.uk X When you're out and on the run,| \ 0865-483389 / \ Dying ain't much of a living, | ~~~~~~~~~~~~~~~~~~~~~~~~~ \ When you're young / ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~Received on Tue Jul 05 1994 - 10:37:36 CEST