Horton

Re: I was spoiled by the MySQL timestamp field

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dennis Gearon <gearond@cvc.net>
Cc: will trillich <will@serensoft.com>, pgsql-general@postgresql.org
Date: 2003-01-24T15:55:26Z
Lists: pgsql-general 
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