Re: I was spoiled by the MySQL timestamp field - Mailing list pgsql-general

From Tom Lane
Subject Re: I was spoiled by the MySQL timestamp field
Date
Msg-id 13482.1043423726@sss.pgh.pa.us
Whole thread Raw
In response to Re: I was spoiled by the MySQL timestamp field  (Dennis Gearon <gearond@cvc.net>)
Responses Re: I was spoiled by the MySQL timestamp field
List 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

pgsql-general by date:

Previous
From: Jochem van Dieten
Date:
Subject: Re: createlang and Schemas
Next
From: "SZŰCS Gábor"
Date:
Subject: Re: 7.2.1: coalesce double-calls function?