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
Example 24.67. 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