| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | timestamp timezone problem |
| Date: | 2005-08-01 17:29:17 |
| Message-ID: | 20050801172917.58863.qmail@web33314.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Afton & Ray Still | 2005-08-01 17:37:37 | Re: timestamp timezone problem |
| Previous Message | operationsengineer1 | 2005-08-01 17:18:17 | qucik timestamp questions |