Convert DateTime to microseconds
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
USupported on UNIX
|
|
microseconds = %DATETIME_TO_I8(datetime)
Return value
microseconds
An i8 value representation of datetime in microseconds. (i8)
Arguments
datetime
A DateTime value to be converted. (a)
Discussion
When using the time key in an ISAM file, the time is represented in microseconds. To select an ISAM record using the time key, you can construct a date and time using the DateTime format (a20), then use this routine to convert it to microseconds for use in the Select statement.
The date and time are passed in the format YYYYMMDDhhmmssuuuuuu:
|
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
%DATETIME_FROM_I8 routine
