Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group