Re: Datetime as a time_t?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ryan Bradetich <ryan_bradetich(at)hp(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: Datetime as a time_t?
Date: 2000-04-06 20:54:06
Message-ID: 28756.955054446@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ryan Bradetich <ryan_bradetich(at)hp(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2000-04-06 21:51:31 Re: Datetime as a time_t?
Previous Message tjk@tksoft.com 2000-04-06 20:18:40 Re: update only if single row