Date fields and libpq....

From: Colin Dick <cdick(at)mail(dot)ocis(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Date fields and libpq....
Date: 1998-06-26 20:12:00
Message-ID: 35940090.3D748711@mail.ocis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there,
I am doing a query on a date field and would like the answer in
epoch time as apposed to a string. I am using PQgetvalue(res,i,0) and
can successfully get the string date as a response. Is it possible to
get an epoch result or do I have to write my own routine to parse the
string into the tm struct so I can use mktime to get the epoch. The
latter solution seems quite a hassle and if anyone has a better
solution, please let me know. Thanks have a good weekend.

--
Colin Dick
Admin, On Call Internet Services
cdick(at)mail(dot)ocis(dot)net

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Colin Dick 1998-06-26 20:28:26 Re: [SQL] Date fields and libpq....
Previous Message Bruce Momjian 1998-06-26 19:13:34 Re: [SQL] isnull function]