How to Substract Milliseconds from A timestamp(3) Field - Mailing list pgsql-novice

From Lane Van Ingen
Subject How to Substract Milliseconds from A timestamp(3) Field
Date
Msg-id TWMAILg40IoWiwXVO3d0000001f@twmail.ESNCC.COM
Whole thread Raw
In response to Re: How to enable remote anoymous logins? (+ admin  (Sean Davis <sdavis2@mail.nih.gov>)
Responses Re: How to Substract Milliseconds from A timestamp(3) Field
List pgsql-novice
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 := ????



pgsql-novice by date:

Previous
From:
Date:
Subject: Re: bad planner pick... but why?
Next
From: "Brandon Aiken"
Date:
Subject: Re: How to Substract Milliseconds from A timestamp(3) Field