| 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 |