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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

> Here is the data definition and the query (version is 7.2.3 btw):
>   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 

Josh Berkus
Aglio Database Solutions
San Francisco

In response to


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-2017 The PostgreSQL Global Development Group