Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Leading Zeros question - Help!
that worked perfect! thanks! very much appreciated!
"wayne" <no_at_email.please.com> wrote in message
news:9fe24r$q7p_at_dispatch.concentric.net...
> Assuming you cannot do a to_char() with a date mask because the hours may
be
> over 24... Try this:
>
> instead of this:
>
> >Mod(TRUNC(((date_fixed - date_arrived) )*24), 1000)
>
> do this:
>
> to_char(Mod(TRUNC(((date_fixed - date_arrived) )*24), 1000), '00')
>
> but if you can keep the hours under 24, then try this:
>
> to_char(date_fixed - date_arrived,'hh24:mi:ss')
>
> HTH
>
>
Received on Mon Jun 04 2001 - 09:16:24 CDT