timezone correction. - Mailing list pgsql-general

From Nikos Mouat
Subject timezone correction.
Date
Msg-id Pine.C=64.4.21.9912060927570.25604-100000@rapture.cyberflunk.com
Whole thread Raw
In response to Re: [GENERAL] null and =  (Lincoln Yeoh <lylyeoh@mecomb.com>)
List 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=>



pgsql-general by date:

Previous
From: Karl DeBisschop
Date:
Subject: concatenating two text attributes
Next
From: Sanchez Diaz Sonia
Date:
Subject: Question?