On Tue, Mar 10, 2009 at 8:43 PM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Hi Everybody,
>
> I have a C program to read a postgres table. One of
> the columns of this table is defined as:
>
> timestamp without time zone
>
> Is there any routine/function that I can use to convert
> this field/column value into unix/linux style date for
> comparison purpose?
select extract('epoch' from timestampfield) ;