Re: [GENERAL] Timestamp/Timezone - does this make sense?

2007-02-14 Thread Ron Johnson 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 02/14/07 01:42, Tom Lane wrote:
 Mike Harding [EMAIL PROTECTED] writes:
 Where does that extra 8 hours come from?
 
 Ellay is 8 hours west of UTC (at least on 1-Jan, at least till our
 congresscritters see fit to monkey with the DST laws again).  What
 problem have you got with these answers?  They look right to me.

I think he's asking why:
select timestamp with time zone '2007-01-01'
at time zone 'America/Los_Angeles';
-
2006-12-31 16:00:00

returns a different value than
select timestamp '2007-01-01'
at time zone 'America/Los_Angeles';

2007-01-01 08:00:00+00
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF0sNSS9HxQb37XmcRAuFXAJ0Z82uaW7FKKAuCnYbrm/bh8MAyCgCfWUW5
2blMHVkmjhYEjsGzk0o+ybM=
=GbW7
-END PGP SIGNATURE-

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

Re: [GENERAL] Timestamp/Timezone - does this make sense?

2007-02-14 Thread Tom Lane 
Ron Johnson [EMAIL PROTECTED] writes:
 I think he's asking why:
 select timestamp with time zone '2007-01-01'
 at time zone 'America/Los_Angeles';
 returns a different value than
 select timestamp '2007-01-01'
 at time zone 'America/Los_Angeles';

Those are transformations in opposite directions; see the manual.

regards, tom lane

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org/

[GENERAL] Timestamp/Timezone - does this make sense?

2007-02-13 Thread Mike Harding 
mvh= set time zone 'UTC';
SET
mvh= select now();
  now  
---
 2007-02-13 03:37:35.660652+00
(1 row)

mvh= select timestamp with time zone '2007-01-01' at time zone
'America/Los_Angeles';
  timezone   
-
 2006-12-31 16:00:00
(1 row)

mvh= select timestamp '2007-01-01' at time zone 'America/Los_Angeles';
timezone

 2007-01-01 08:00:00+00
(1 row)

Where does that extra 8 hours come from?



---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [GENERAL] Timestamp/Timezone - does this make sense?

2007-02-13 Thread Tom Lane 
Mike Harding [EMAIL PROTECTED] writes:
 Where does that extra 8 hours come from?

Ellay is 8 hours west of UTC (at least on 1-Jan, at least till our
congresscritters see fit to monkey with the DST laws again).  What
problem have you got with these answers?  They look right to me.

regards, tom lane

---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
   choose an index scan if your joining column's datatypes do not
   match