Name
now — returns the current transaction timestamp
Synopsis
now
(
|
); |
Description
Now returns the timestamp associated with current transaction as a DATETIME. This value is guaranteed to differ from the timestamp of any other transaction.
Examples
Example 24.251. Get a timestamp
Get a timestamp in human-readable form.
SQL> select datestring(now()), cast (now() as VARCHAR);
callret callret
VARCHAR VARCHAR
_______________________________________________________________________________
2001-10-08 16:31:49.000000 2001-10-08 16:31:49.000000
1 Rows. -- 99 msec.
Example 24.252. Table example
Store update time in a column
SQL> update test_table set TIME_CHANGED = now();
Done. -- 37 msec.
SQL> select cast (TIME_CHANGED as VARCHAR) from test_table;
callret
VARCHAR
_______________________________________________________________________________
2001-10-08 16:34:28.000000
1 Rows. -- 3 msec.
Parameters
now has no parameters.
Return Types
A DATETIME timestamp.
Errors
now does not return errors.