Date & Time with time zone - Mailing list pgsql-general

From Wei Wei
Subject Date & Time with time zone
Date
Msg-id 20060409200750.C72D2CA0AF@ws7-4.us4.outblaze.com
Whole thread Raw
Responses Re: Date & Time with time zone  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
I try to understand how the D&T information is stored/presented in PG. In the application, the data is reported as

Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time

But, in the DB, it is stated as

2006-04-09 14:40:53.093-07

It doesn't seen right to me. Both are on the same box and the date column is with time zone.

Any thought?



Thanks.



--
_______________________________________________

Search for businesses by name, location, or phone number.  -Lycos Yellow Pages

http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Next
From: "Milen Kulev"
Date:
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )