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)) )