Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Datetime as a time_t?
Date
Msg-id 28756.955054446@sss.pgh.pa.us
Whole thread Raw
In response to Datetime as a time_t?  (Ryan Bradetich <ryan_bradetich@hp.com>)
List pgsql-sql
Tree view 
Ryan Bradetich <ryan_bradetich@hp.com> writes:
> Does anyone know how to extract a datetime field as a time_t?

date_part('epoch', ...);

Not exactly the first thing you'd think to try, but it works.
        regards, tom lane

pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: update only if single row
Next
From: Frank Bax
Date:
Subject: Re: Datetime as a time_t?