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
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 P
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
In a query, there is something like
order by count(id)/age
where both id and age are the integer data type.
>From a query result, I believe the operation count(id)/age yields a integer. I
>need it in real data type. After searching the online document, I haven't
>found any related informatio
