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