Re: any way to convert date via libpq?

On Wed, Mar 11, 2009 at 12:07 AM, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu> wrote:
> Hi Scott,
>
> Many thanks for your reply.
> I just tried:
>   select extract (epoch from timestamp with time zone '2008-04-04
> 20:00:0.0');
> and got:
>   1207364400
> which is great!
>
> I suppose there is no problem running this query
> via PGexec() in a C program?  Something like:
>   result = PGexec (conn, "FETCH ALL from somePort");

It's definitely accessable by anything connecting to the db. Not sure
how that's done in C so someone else will have to chip in on that.