Postgres Pro
Downloads
Home   >   mailing lists

Re: Datetime as a time_t? - Mailing list pgsql-sql

From Frank Bax
Subject Re: Datetime as a time_t?
Date
Msg-id 3.0.6.32.20000406175131.014ded10@execulink.com
Whole thread Raw
In response to Datetime as a time_t?  (Ryan Bradetich <ryan_bradetich@hp.com>)
List pgsql-sql
Tree view 
At 10:27 AM 4/06/00 -0600, Ryan Bradetich wrote:
>Does anyone know how to extract a datetime field as a time_t?
>My understanding is that PostgreSQL stores dates internally
>as a time_t, but I have not figured out how to extract them in
>that format.
abstime(datetime_field)::int8

works for both datetime and timestamp fields.

Frank

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Datetime as a time_t?
Next
From: "Leonid P. Klemjatsionok"
Date:
Subject: Re: update only if single row