Greetings
I'm in Florida (Eastern Time Zone / New York), using Ubuntu 10.04LTS /
Postgresql 8.4.7.
My default timestamps in my database all are +5 hours in the future
(probably GMT), unless I code the 'EST' time zone into the field's default
(timezone('EST'::text, now())).If I use now() it is +5 h
35 PM
To: Kevin Grittner
Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] LOCALTIMESTAMP has wrong time zone
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
>> My default timestamps in my database all are +5 hours in the future
> Can you c
0) WITHOUT TIME ZONE DEFAULT
'now'::text::timestamp without time zone,
CONSTRAINT "pk_general_comments_commentid" PRIMARY KEY("commentid"),
) WITH OIDS;
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, February 24, 201
!
JB
-Original Message-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Friday, February 25, 2011 11:15 AM
To: j...@blackskytech.com; pgsql-bugs@postgresql.org; 'Tom Lane'
Subject: RE: [BUGS] LOCALTIMESTAMP has wrong time zone
"Jonathan Brinkman" wrote:
>
My TO_CHAR function is now an hour off thanks to Daylight Savings Time.
The dates are correct (I'm in EST: TZ=-04) but my function now returns TIME
an hour early.
(prior to DST we were TZ=-05).
TIMESTAMPTZ data (v_dt): 2011-03-17 18:21:50-04
FUNCTION SNIPPET: to_char(v_dt, 'mm/dd/ hh:mi AM')
ne 'America/New_York'; and retried the select
now(), and now it is correct.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Friday, March 18, 2011 11:42 AM
To: j...@blackskytech.com
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,dat
mailto:t...@sss.pgh.pa.us]
Sent: Friday, March 18, 2011 12:47 PM
To: Kevin Grittner
Cc: j...@blackskytech.com; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST
change
"Kevin Grittner" writes:
> "Jonathan Brinkman" wrote:
1 row)
bucardo@Cloud-DB1:~$ psql beta_cms_main -c "select now();"
now
---
2011-03-21 09:23:03.079692-04
(1 row)
bucardo@Cloud-DB1:~$ logout
postgres@Cloud-DB1:~$ psql beta_cms_main -c "SHOW TIME ZONE;"
TimeZone
--
EST
ge-
From: Robert Haas [mailto:robertmh...@gmail.com]
Sent: Monday, March 21, 2011 11:50 AM
To: j...@blackskytech.com
Cc: Tom Lane; Kevin Grittner; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST
change
On Mon, Mar 21, 2011 at 9:13 AM, Jonathan
