Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Leading Zeros question - Help!
just wondering, what is the datatype of date_fixed and date_arrived ? DATE or NUMBER ?
"Amanda Zaborowski" <azaborow_at_mindspring.com> wrote in message
news:9fg3gl$cig$1_at_slb2.atl.mindspring.net...
> 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 - 20:20:07 CDT