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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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