Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Question 2 Interval and timestamptz



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group