time format

[#1]

hi,

i have two kind of time formats:

00:01:10 wich is hh:mm:ss and 01:10 wich is mm:ss.

i need to convert the second format to hh:mm:ss

how can i do this?

i've tried with timestamp# (date,'hh:mm:ss') and whit Date#(date,'hh:mm:ss) but it didn't do what i need.

thanks for your help!

[swuehl]

Try using the alt() function in combination with interval# / interval functions:

LOAD

...

interval(alt(interval#(Duration,'hh:mm:ss'),interval#(Duration,'mm:ss')),'hh:mm:ss') as NewField,

...

FROM ...

[Jason_Michaelides · Accepted solution]

try:

Time(Time#(Duration,'mm:ss'),'hh:mm:ss')

Hope this helps,

Jason

[#4]

thanks for your answer it really helped me.