Name
sysutcdatetime — returns current datetime in GMT timezone with adjusted fractional part of seconds
Synopsis
sysutcdatetime ( |
in fraction_microseconds integer
) ; |
Description
The function returns current datetime, like now()
, but fractional part of seconds can be
adjusted by providing the number of "microseconds" as the
argument.
The function is similar to curdatetime()
but the returned datetime is in
GMT timezone.
Parameters
fraction_microseconds
Microseconds.
Return Types
A DATETIME timestamp.
Errors
sysutcdatetime
does not return
errors.
Examples
Example24.66.Get a timestamp
Get a timestamp in human-readable form.
SQL> select sysutcdatetime(); DATETIME 2015-05-04 13:11:30.701568 No. of rows in result: 1 SQL>select sysutcdatetime(1); DATETIME 2015-05-04 13:11:41 No. of rows in result: 1