Re: Datetime - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Datetime
Date
Msg-id B161AE30-E550-11D8-8966-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: Datetime  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: Datetime  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Aug 3, 2004, at 8:50 PM, Achilleus Mantzios wrote:

> O kyrios Michael Glaesemann egrapse stis Aug 3, 2004 :
>>
>> I believe this is incorrect. I believe PostgreSQL uses its own
>
> Do you suggest postgresql has any other means of getting
> time except the time(2) syscall??
>
>> timestamp datatype internally (which is, indeed, not as text in an
>> easy-to-read form). On my machine (running cvs-head),

No. I'm just saying that PostgreSQL does not represent or store 
timestamps as epoch timestamps internally. I don't know for sure how 
PostgreSQL gets the current timestamp, and I wouldn't be surprised if 
it was via the time(2) syscall.

Michael Glaesemann
grzm myrealbox com



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: Datetime
Next
From: Tom Lane
Date:
Subject: Re: Datetime