From: | Chris Bowlby <excalibur(at)hub(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | datetime function |
Date: | 2002-08-07 17:33:44 |
Message-ID: | 20020807143251.B783-100000@wired.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Guy's,
Noticing an issue with the datetime funciton when being used with
'epoch', it is giving different results then before..
select version();
version
---------------------------------------------------------------------
PostgreSQL 7.1.2 on i386-unknown-freebsd4.3, compiled by GCC 2.95.3
(1 row)
set time zone 'GMT';
SET VARIABLE
select datetime('epoch') + "interval"('0 seconds');
?column?
------------------------
1970-01-01 00:00:00+00
(1 row)
set time zone 'PST8PDT';
SET VARIABLE
select datetime('epoch') + "interval"('0 seconds');
?column?
------------------------
1969-12-31 16:00:00-08
(1 row)
==========================================================================
select version();
version
---------------------------------------------------------------------
PostgreSQL 7.2.1 on i386-unknown-freebsd4.3, compiled by GCC 2.95.3
(1 row)
set time zone 'GMT';
SET VARIABLE
select datetime('epoch') + "interval"('0 seconds');
?column?
---------------------
1970-01-01 00:00:00 <== what's happened to the offset , i.e. "+00" ?
(1 row)
set time zone 'PST8PDT';
SET VARIABLE
select datetime('epoch') + "interval"('0 seconds');
?column?
---------------------
1970-01-01 00:00:00 <== why is this not "1969-12-31 16:00:00-08" ?
(1 row)
Chris Bowlby,
-----------------------------------------------------
Manager of Information and Technology.
excalibur(at)hub(dot)org
www.hub.org
1-902-542-3657
-----------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2002-08-07 18:00:39 | Re: Importing blob |
Previous Message | Richard Huxton | 2002-08-07 17:28:25 | Re: still lost: Cannot use more than 16 attributes in an index |