Question 2 Interval and timestamptz

Поиск
Список
Период
Сортировка
От Shawn
Тема Question 2 Interval and timestamptz
Дата
Msg-id 200803261605.56116.postgres@xmtservices.net
обсуждение исходный текст
Список pgsql-sql
Hello!

The second part of my question is:

Given a value as an interval, see previous posting, is there a simply method 
to take a given timestamptz value and a given interval value and create the 
sum or difference of the 2 in timestamptz format?

The scenario is that the afore mentioned tables, see previous post, in 
addition to the duration varchar field, also have a field called event_at_utc 
which is a timestamptz type.  I need to calculate the end time of the event 
given the interval calculated from the duration (varchar) field.

Any all all help is greatly appreciated.

Shawn


В списке pgsql-sql по дате отправления:

Предыдущее
От: Shawn
Дата:
Сообщение: Part 1 of several - Converting a varchar to an interval
Следующее
От: Shane Ambler
Дата:
Сообщение: Re: Export Access 97 to PostgreSQL