Re: Leading Zeros question - Help!

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 Sun Jun 03 2001 - 14:11:23 CDT