Date & Time with time zone

From: "Wei Wei" <wei725(at)lycos(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Date & Time with time zone
Date: 2006-04-09 20:07:50
Message-ID: 20060409200750.C72D2CA0AF@ws7-4.us4.outblaze.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hoskin 2006-04-09 20:23:01 Expression matching related question
Previous Message Milen Kulev 2006-04-09 20:06:58 Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )