Postgres Pro
Downloads
Home   >   mailing lists

Datetime as a time_t? - Mailing list pgsql-sql

From Ryan Bradetich
Subject Datetime as a time_t?
Date
Msg-id 38ECBAD4.E13DD27B@hp.com
Whole thread Raw
Responses Re: Datetime as a time_t?  (Michael Fork <mfork@toledolink.com>)
Re: Datetime as a time_t?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Datetime as a time_t?  (Frank Bax <fbax@execulink.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Antonio W. Lagnada"
Date:
Subject: Re: libpq
Next
From: Frank Bax
Date:
Subject: update only if single row