On Wed, Mar 11, 2009 at 12:07 AM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
