pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Colin Dick <cdick@mail.ocis.net>
To: pgsql-sql@postgresql.org
Subject: Date fields and libpq....
Date: Fri, 26 Jun 1998 13:12:00 -0700
Message-ID: <35940090.3D748711@mail.ocis.net> (raw)

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




view thread (7+ messages)  latest in thread

Message-ID: <35940090.3D748711@mail.ocis.net>
Permalink:  ../35940090.3D748711@mail.ocis.net/
Also on:    postgresql.org/message-id/35940090.3D748711@mail.ocis.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: cdick@mail.ocis.net
  Subject: Re: Date fields and libpq....
  In-Reply-To: <35940090.3D748711@mail.ocis.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox