Name

curdatetime — returns current datetime with adjusted fractional part of seconds

Synopsis

curdatetime ( 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.

Parameters

fraction_microseconds

Microseconds.

Return Types

A DATETIME timestamp.

Errors

curdatetime does not return errors.

Examples

Example24.63.Get a timestamp

Get a timestamp in human-readable form.

SQL> select curdatetime();
DATETIME
2015-05-04 09:02:05.242215
No. of rows in result: 1

SQL>select curdatetime(1);
DATETIME
2015-05-04 09:02:47
No. of rows in result: 1