How to conver integer to time value

narayanan

I want to convert a integer value to time value.... any suggestions please?

fb

You can add an integer to a 'zero' time variable giving a time value that is 'integer' milliseconds after midnight...

MyTime := 000000T +
  (intHours * 60 * 60 * 1000) +
  (intMinutes * 60 * 1000) +
  (intSeconds * 1000) +
  (intMilliseconds);

Draqos

Declare time as Time and Inetger as Int.

EVALUATE(time,STRSUBSTNO('%1',integer));

After this, if integer was 112, time will be 11:02:00
Hope this helps