Re: Problem with timestamp - Pls help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Kumar <sgnerd(at)yahoo(dot)com(dot)sg>, psql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Problem with timestamp - Pls help
Date: 2003-09-19 16:27:26
Message-ID: 21870.1063988846@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message ow 2003-09-19 18:47:16 psql output and password Qs
Previous Message Stephan Szabo 2003-09-19 15:59:19 Re: Problem with timestamp - Pls help