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

Re: date arithmetic with columns

From: hari(dot)fuchs(at)gmail(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: date arithmetic with columns
Date: 2012-03-04 09:45:18
Message-ID: 87hay4pump.fsf@hf.protecting.net (view raw or flat)
Thread:
Lists: pgsql-sql
Peter Faulks <faulksp(at)iinet(dot)net(dot)au> writes:

> I have two columns in two distinct tables, one is the starting time of
> an event, timestamp without time zone. Data is the utc datetime (for
> sorting across time zones), the other is the number of minutes to add.

Maybe I'm missing something, but why don't you just use timestamp with
timezone instead?


In response to

Responses

pgsql-sql by date

Next:From: Peter FaulksDate: 2012-03-04 11:29:23
Subject: Re: date arithmetic with columns
Previous:From: Jasen BettsDate: 2012-03-04 08:56:31
Subject: Re: Problems with ODBC connections

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