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@hub.org
www.hub.org
1-902-542-3657
-----------------------------------------------------