Re: any way to convert date via libpq? - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: any way to convert date via libpq?
Date
Msg-id dcc563d10903102155y3ef3fcb3ydf7010aad0346c0b@mail.gmail.com
Whole thread Raw
In response to any way to convert date via libpq?  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List pgsql-admin
On Tue, Mar 10, 2009 at 8:43 PM, Tena Sakai <tsakai@gallo.ucsf.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) ;

pgsql-admin by date:

Previous
From: "Tena Sakai"
Date:
Subject: any way to convert date via libpq?
Next
From: "Tena Sakai"
Date:
Subject: Re: any way to convert date via libpq?