Re: casting... adding integer to timestamp

From: Mark Gibson <mark(at)gibsonsoftware(dot)com>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: casting... adding integer to timestamp
Date: 2006-06-25 22:21:10
Message-ID: 449F0C56.4040206@gibsonsoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Glaesemann wrote:
>
> On Jun 25, 2006, at 14:23 , Mark Gibson wrote:
>
>> SELECT play_length - INTERVAL 'play_seconds seconds' ...
>
> The column isn't interpolated into the string. Try
>
> SELECT play_length - play_seconds * INTERVAL '1 second'
>

That worked great! Thanks!

Mark

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark Gibson 2006-06-25 22:24:49 Casting and Timestamp
Previous Message brian ally 2006-06-25 19:14:41 oh dear - have i messed up my OIDs?