Search Postgresql Archives

Date & Time with time zone

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux