Re: Timezone troubles

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jesse Scott <scotje(at)wwc(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Timezone troubles
Date: 2003-08-14 04:12:44
Message-ID: 200308132112.44171.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Jesse,

> Here is the data definition and the query (version is 7.2.3 btw):
<snip>
> lastlogin timestamp DEFAULT 'now',
> firstlogin timestamp,

In 7.2.x, unless you declare a timestamp as "TIMESTAMP WITHOUT TIME ZONE", it
is automatically created as *with* time zone. I think this may be your
problem.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jesse Scott 2003-08-14 04:38:37 Re: Timezone troubles
Previous Message Abdul Wahab Dahalan 2003-08-14 03:35:21 Re: How to speeed up the query performance