08-26-2011 10:16 AM
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 .
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 .