From: | Shawn <postgres(at)xmtservices(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Question 2 Interval and timestamptz |
Date: | 2008-03-26 16:05:56 |
Message-ID: | 200803261605.56116.postgres@xmtservices.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2008-03-26 16:15:39 | Re: Export Access 97 to PostgreSQL |
Previous Message | Shawn | 2008-03-26 15:56:54 | Part 1 of several - Converting a varchar to an interval |