Now returns the timestamp associated with current transaction as a DATETIME. This value is guaranteed to differ from the timestamp of any other transaction.
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.
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.
now has no parameters.
A DATETIME timestamp.
now does not return errors.