Re: Datetime as a time_t?

From: Frank Bax <fbax(at)execulink(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: Datetime as a time_t?
Date: 2000-04-06 21:51:31
Message-ID: 3.0.6.32.20000406175131.014ded10@execulink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Leonid P. Klemjatsionok 2000-04-07 07:28:27 Re: update only if single row
Previous Message Tom Lane 2000-04-06 20:54:06 Re: Datetime as a time_t?