27;t:
select now() at time zone 'Australia/ATC'
supposed to be:
select now() at time zone 'Australia/ACT'
And looking at the pg_timezone_names table for EST, there's only one entry
for EST:
SELECT * from pg_timezone_names where name = 'EST';
name | abbrev | utc_offset | is_dst
--+++
EST | EST| -05:00:00 | f
--
JC de Villa
>
>
>
Well, per the docs at
http://www.postgresql.org/docs/9.1/static/functions-datetime.html, in
parens under timezone:
"Technically, PostgreSQL uses UT1because leap seconds are not handled."
Although there is a footnote on that page that states that:
"60 if leap seconds are implemented by the operating system".
--
JC de Villa
