From: | "Octavio Alvarez" <alvarezp(at)alvarezp(dot)ods(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, "Rob Richardson" <Rob(dot)Richardson(at)rad-con(dot)com> |
Subject: | Re: How do i calculate a finish time when the start time is ambiguous? |
Date: | 2011-03-28 19:27:38 |
Message-ID: | op.vs2izxv94oyyg1@alvarezp-ws |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 28 Mar 2011 08:26:03 -0700, Rob Richardson
<Rob(dot)Richardson(at)rad-con(dot)com> wrote:
> I have a table that records a starting time for a process and the length
> of time that process will take, and I need to calculate the time the
> process will end. I have the starting time both in local time and in
> UTC time, but for reasons which I consider totally idiotic, they are
> timestamp fields, not timestamptz fields. My calculation must take into
> account the possibility that time will change from standard to daylight
> time or vice versa during the interval.
>
>
> But I'm having a difficult time coming up with a function that will use
> this information.
I suggest you calculate your finish time in UTC (since that number is not
ambiguous). You, then, do convert it to whatever TZ you need.
Cheers.
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2011-03-28 20:09:38 | Re: can a function have a setof (returned from another function) as input |
Previous Message | Pavel Stehule | 2011-03-28 19:24:08 | Re: can a function have a setof (returned from another function) as input |