Storing timestamps in text format - Mailing list pgsql-jdbc

From Radosław Smogura
Subject Storing timestamps in text format
Date
Msg-id fc18163a29b69fecf56d6fd2dfdceccd@smogura-softworks.eu
Whole thread Raw
Responses Re: Storing timestamps in text format  (Dave Cramer <pg@fastcrypt.com>)
Re: Storing timestamps in text format  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Hi,

I perform following test:
1. Open connection (GMT+1)
2. Change timezone (GMT+3)
3. Write created timestamp.
4. Change timezone to different connection open and write (GMT+4)
5. Read timezone

During this I saw driver sends timestamp encoded with initial (in my case
+1), form connection open, time zone. It's because
TimestampUtils.toString(Calendar, Timestamp) uses defaultCal. Should it use
Calendar.getInstance() or new GregorianCalendar?

    public synchronized String toString(Calendar cal, Timestamp x) {
        if (cal == null)
            cal = defaultCal; // = Calendar.getInstance() // new
GregorianCalendar()


--
----------
Radosław Smogura
http://www.softperience.eu

pgsql-jdbc by date:

Previous
From: Radosław Smogura
Date:
Subject: Re: Workarounds for getBinaryStream returning ByteArrayInputStream on bytea
Next
From: Francesco Degrassi
Date:
Subject: Postgresql XA prepare() method behaviour