Dennis Gearon <gearond(at)cvc(dot)net> writes:
> What's the difference between 'now()' and 'current_timestamp' ?
None AFAIK. now() is historical Postgres usage, CURRENT_TIMESTAMP is
the SQL-spec-mandated spelling of the same functionality.
CURRENT_TIMESTAMP with an argument does something a bit different,
though.
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
regards, tom lane