Re: casting... adding integer to timestamp

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: Mark Gibson <mark(at)gibsonsoftware(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: casting... adding integer to timestamp
Date: 2006-06-25 05:54:17
Message-ID: D2195042-5687-4B5F-87A2-B0E13B695EBA@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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'

Hope this helps.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Finner 2006-06-25 06:28:23 Re: casting... adding integer to timestamp
Previous Message Mark Gibson 2006-06-25 05:23:57 casting... adding integer to timestamp