On Wed, Jan 5, 2011 at 6:10 AM, Gouse wrote:
> // snippet of the stored procedure...
> CREATE OR REPLACE FUNCTION wf_to_timestamp("varchar")
> RETURNS timestamptz AS
> $BODY$
> select to_timestamp($1,'-MM-DD HH24:MI:SS.MS')+ interval '1 hour' *
> (extract(timezone from to_timestamp($1,'-
Thanks Tom for the Update.
You are correct that there is not local date and time for that DST time
period as clocks jump to 2 A.M.
The problem i am seeing here is that, we have a small stored procedure
written which will always take UTC time as parameter and should convert it
to local timestamp
On Fri, Dec 31, 2010 at 4:01 AM, Aren Cambre wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5808
> Logged by: Aren Cambre
> Email address: a...@arencambre.com
> PostgreSQL version: 9.0.2
> Operating system: Windows 7 32 bit
> Description: Remove
