Convert microseconds to DateTime format
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
USupported on UNIX
|
VSupported on OpenVMS
|
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
