Prev Up Next
nntp_post Home DB.DBA.AMAZON_START_INSTANCE

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

Example24.227.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.

Example24.228.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.

Prev Up Next
nntp_post Home DB.DBA.AMAZON_START_INSTANCE