Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Question 2 Inte...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 3360 of 3799
Post > Topic >>

Question 2 Interval and timestamptz

by postgres@[EMAIL PROTECTED] (Shawn) Mar 26, 2008 at 04:05 PM

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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
 




 1 Posts in Topic:
Question 2 Interval and timestamptz
postgres@[EMAIL PROTECTED  2008-03-26 16:05:56 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 21:57:01 CST 2008.