Re: Datetime as a time_t?

I have done the following to return a datetime field in unix form:

select datepart('epoch', datetime) from table;

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio

On Thu, 6 Apr 2000, Ryan Bradetich wrote:

> Hello,
>
> 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.
>
> I have looked at the casting, and the set datestyles so far.
> Any ideas?
>
> Thanks,
>
> -Ryan
>
> P.S. I am using PostgreSQL 6.5.3
>
>