timestamp timezone problem
От | |
---|---|
Тема | timestamp timezone problem |
Дата | |
Msg-id | 20050801172917.58863.qmail@web33314.mail.mud.yahoo.com обсуждение исходный текст |
Ответ на | Re: change column length, is it that hard? (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: timestamp timezone problem
|
Список | pgsql-novice |
when i run the following query select now()::timestamptz in pgadmin3's sql window, it ends with -07. as i understand it, that is the time zone. my computer is GMT-8 since i'm in the pacific time zone. why is there a discrepancy - or is it just me not knowing the nuts and bolts of what is going on? to tz or not tz? that is the question. i think i want to tz b/c i can't guarantee that tz won't become relevant in the future (ie, data may be entered from two different time zones a report may want to compare the dates). any advice would be appreciated. tia... ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
В списке pgsql-novice по дате отправления: