Date fields and libpq....

Поиск
Список
Период
Сортировка
От Colin Dick
Тема Date fields and libpq....
Дата
Msg-id 35940090.3D748711@mail.ocis.net
обсуждение исходный текст
Ответы Re: [SQL] Date fields and libpq....  (Colin Dick <cdick@mail.ocis.net>)
Список 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@mail.ocis.net


В списке pgsql-sql по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] isnull function]
Следующее
От: Colin Dick
Дата:
Сообщение: Re: [SQL] Date fields and libpq....