%DATETIME_FROM_I8

Convert microseconds to DateTime format

WTSupported in traditional Synergy on Windows
WNSupported in Synergy .NET on Windows
USupported on UNIX

 

datetime = %DATETIME_FROM_I8(microseconds)

Return value

datetime

The date and time returned in the format YYYYMMDDhhmmssuuuuuu. (a)

Arguments

microseconds

A date and time in microseconds to be converted. (i8)

Discussion

When using the time autokey in an ISAM file, the time is represented in microseconds. To convert that to DateTime format, use %DATETIME_FROM_I8.

The YYYYMMDDhhmmssuuuuuu represents the following:

YYYY

The four-digit year (for example, 2016)

MM

The month (01 through 12)

DD

The day of the month (01 through 31)

hh

The hour (00 through 23)

mm

The minute of the hour (00 through 59)

ss

The second of the minute (00 through 59)

uuuuuu

The microseconds (000000 through 999999)

See also

%WKDAY routine