Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 25 Jun 2006 14:54:17 +0900
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
- Follow-Ups:
- Re: casting... adding integer to timestamp
- From: Mark Gibson
- Re: casting... adding integer to timestamp
- References:
- casting... adding integer to timestamp
- From: Mark Gibson
- casting... adding integer to timestamp
- Prev by Date: casting... adding integer to timestamp
- Next by Date: Re: casting... adding integer to timestamp
- Previous by thread: casting... adding integer to timestamp
- Next by thread: Re: casting... adding integer to timestamp
- Indexes: