Re: Timezone troubles - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Timezone troubles
Date
Msg-id 200308132112.44171.josh@agliodbs.com
Whole thread Raw
In response to Timezone troubles  (Jesse Scott <scotje@wwc.edu>)
Responses Re: Timezone troubles
List 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


pgsql-sql by date:

Previous
From: Abdul Wahab Dahalan
Date:
Subject: Re: How to speeed up the query performance
Next
From: Jesse Scott
Date:
Subject: Re: Timezone troubles