Re: [GENERAL] timezone difference in timestamp?

2006-11-06 Thread meltedown
Tom Lane wrote: meltedown <[EMAIL PROTECTED]> writes: Short version: I'm trying to turn a unix timestamp into a psql timestamp, but there is a 5 hour difference. Is this because of timezones ? Can I just subtract 5 hours to get the right value ? "select timestamp '1

[GENERAL] timezone difference in timestamp?

2006-11-06 Thread meltedown
Short version: I'm trying to turn a unix timestamp into a psql timestamp, but there is a 5 hour difference. Is this because of timezones ? Can I just subtract 5 hours to get the right value ? Detailed version: I start with a unix timestamp: $startofday =1162789200; Which has this date: Array (