How to Substract Milliseconds from A timestamp(3) Field

Поиск
Список
Период
Сортировка
От Lane Van Ingen
Тема How to Substract Milliseconds from A timestamp(3) Field
Дата
Msg-id TWMAILg40IoWiwXVO3d0000001f@twmail.ESNCC.COM
обсуждение исходный текст
Ответ на Re: How to enable remote anoymous logins? (+ admin  (Sean Davis <sdavis2@mail.nih.gov>)
Ответы Re: How to Substract Milliseconds from A timestamp(3) Field  ("Brandon Aiken" <BAiken@winemantech.com>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: bad planner pick... but why?
Следующее
От: "Brandon Aiken"
Дата:
Сообщение: Re: How to Substract Milliseconds from A timestamp(3) Field