timezone correction.

From: Nikos Mouat <nikm(at)cyberflunk(dot)com>
To: pgsql-general(at)postgreSQL(dot)org
Subject: timezone correction.
Date: 1999-12-06 17:28:46
Message-ID: Pine.C=64.4.21.9912060927570.25604-100000@rapture.cyberflunk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Is this a bug?

bleah=> select ('Mon Nov 29 21:47:04 PST 1999'::timestamp);
?column?
----------------------
1999-11-30 00:47:04-05
(1 row)

bleah=> select ('Mon Nov 29 21:47:04 PST 1999'::timestamp)::date;
?column?
----------
11-29-1999
(1 row)

bleah=>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sanchez Diaz Sonia 1999-12-06 19:22:35 Question?
Previous Message Rich Ackerman 1999-12-06 17:00:38 backup strategy