Re: I was spoiled by the MySQL timestamp field

Dennis Gearon <gearond@cvc.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