decimal value conversion to time format

Database
Highlighted
Enthusiast

decimal value conversion to time format

Hi

when we are try to convert the Decimal value to Time format . im using the  mentioned logic

( (PRINT_TIME /100) (FORMAT '999999') (CHAR(6)) (TIME(0)) )

but  for some values im facing an issue .

ex:  1233812

       1233793

when it is converting  to time it is showing me the same value .  That is 

1233812   ------  01:23:38

1233793  --------  01:23:38   it should be 01:23:37 .

 

 

please suggest me how to resolve it .


1 REPLY
Enthusiast

Re: decimal value conversion to time format

( (PRINT_TIME /100) (FORMAT '99:99:99') (CHAR(11)) (TIME(0)) )