Load number as string

[julruiz123]

Hi,

I have the next situation, in a database is stored the time as follow

9.01

6.45

7.10

8.10

So i need replace point by colon, but the string change as follows

7:1

8:1

How i can prevent the zero runs out?

Thanks.

[julruiz123]

This is the script that i tried

A01:

LOAD tradoc,

           trahoi,

     Time(Time#(trahoi,'hh.mm'),'hh:mm TT') as trahoi1

FROM

INMTRA_EXT_Copia.qvd

(qvd);

and this is the result

[julruiz123 · Accepted solution]

Hi,

This is the solution

Time(Time#(Num(trahoi,'00.00'),'hh.mm'),'hh:mm TT') as trahoi1

Thanks for the help!