Re: Storing timestamps in text format

On Fri, Nov 26, 2010 at 1:28 PM, Radosław Smogura
<rsmogura(at)softperience(dot)eu> wrote:
> 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()
>

What do you expect it to do?

>
> --
> ----------
> Radosław Smogura
> http://www.softperience.eu
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>