"Wei Wei" <[EMAIL PROTECTED]> writes:
> A returned value of "select new()" is correct, but the TZ is -7 where
> the TZ of OS is set to Pacific Day Time Saving Time.
That sounds like PG is working like it's supposed to.
> The application is
> written with Java. And I use the Java API Calendar cl
Thanks for your response, Tom.
And please see the below.
> > In the application, the data is reported as
> >
> > Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
> >
> > But, in the DB, it is stated as
> >
> > 2006-04-09 14:40:53.093-07
> >
> > It doesn't seen right to me. Both are on the sa
"Wei Wei" <[EMAIL PROTECTED]> writes:
> In the application, the data is reported as
>
> Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
>
> But, in the DB, it is stated as
>
> 2006-04-09 14:40:53.093-07
>
> It doesn't seen right to me. Both are on the same box and the
> date column is wit
Thanks for your reply, Martijn. And see below.
> On Sun, Apr 09, 2006 at 12:07:50PM -0800, Wei Wei wrote:
> > I try to understand how the D&T information is stored/presented
> > in PG. In the application, the data is reported as
> >
> > Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
> >
> >
On Sun, Apr 09, 2006 at 12:07:50PM -0800, Wei Wei wrote:
> I try to understand how the D&T information is stored/presented in PG. In the
> application, the data is reported as
>
> Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
>
> But, in the DB, it is stated as
>
> 2006-04-09 14:40:53.09
I try to understand how the D&T information is stored/presented in PG. In the
application, the data is reported as
Sun Apr 09 12:40:52 PDT 2006 - Pacific Standard Time
But, in the DB, it is stated as
2006-04-09 14:40:53.093-07
It doesn't seen right to me. Both are on the same box and the date