Re: timestamp timezone problem - Mailing list pgsql-novice

From Afton & Ray Still
Subject Re: timestamp timezone problem
Date
Msg-id 005501c596bf$b5a4e610$7c884146@rayshome
Whole thread Raw
In response to timestamp timezone problem  (<operationsengineer1@yahoo.com>)
List pgsql-novice
----- Original Message -----
From: <operationsengineer1@yahoo.com>
To: <pgsql-novice@postgresql.org>
Sent: Monday, August 01, 2005 11:29 AM
Subject: [NOVICE] timestamp timezone problem


> 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.

Daylight Savings?  (One hour eariler than normal)

>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005
>
>


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.7/60 - Release Date: 7/28/2005


pgsql-novice by date:

Previous
From:
Date:
Subject: timestamp timezone problem
Next
From: Dane Ensign
Date:
Subject: os x and initdb data directory