SELECT (end_time - interval '00:00:05') AS work_timestamp FROM mytable;
--
Brandon Aiken
CS/IT Systems Engineer
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Lane Van Ingen
Sent: Tuesday, October 17, 2006 2:33 PM
To: pgsql-novice@postgresql.org
Subject: [NOVICE] How to Substract Milliseconds from A timestamp(3)
Field
In PLPGSQL, does anyone know how to subtract MILLISECONDS from a field
defined as timestamp(3), yielding another field defined as timestamp(3)?
Have been trying interval, and conversion functions but no luck.
Example: '2006-10-17 14:23:28.951'; subtract 5 milliseconds from a field
called mytable.end_time, and return the results to a field named
work_timestamp.
work_timestamp := ????
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
