Re: Problem with timestamp - Pls help - Mailing list pgsql-sql

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> I think select CAST(CURRENT_TIMESTAMP(0) AS timestamp without time zone)
> may get you what you want without having to rely on the text format.

If you don't want the time zone, there's also LOCALTIMESTAMP(n).  See
http://www.postgresql.org/docs/7.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
        regards, tom lane