-------------- Forwarded Message: -------------- From: [EMAIL PROTECTED] (Adrian Klaver) To: Shawn <[EMAIL PROTECTED]> Subject: Re: [SQL] Question 2 Interval and timestamptz Date: Wed, 26 Mar 2008 16:24:39 +0000 > > -------------- Original message ---------------------- > From: Shawn <[EMAIL PROTECTED]> > > 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 > > > > select '2008-03-26 09:21:44':: timestamptz + (('134987'::int/1000)* interval '1 second'); ?column? ------------------------ 2008-03-26 09:23:58-07 (1 row)
Forgot to Reply All. -- Adrian Klaver [EMAIL PROTECTED] -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql