Re: postgres lists

On Sun, 29 Nov 1998, Vulcana wrote:

> Hi sorry to disturb but I tried mailing to
> psql-questions(at)postgres(dot)org
> and got a user unknown
> I then tried mailing
> psql-questions-request(at)postgres(dot)org
> and had the same responce

pgsql-questions is dead. either address the problem in pgsql-interfaces
or pgsql-general. i've cc'd the list (and those replying take note that
she's not in the list).

> Do you know what is going on with the lists? Or barring that do you know
> someone who might have an answer to the following question
> ***********************************************************************
> Subject: C program Postgres 6.3 and date
>
>
> Hi, first thing of note is that I'm not on the list so please email
> solutions to me.
>
> I recently upgraded postgres from version ~6 to 6.3. Unfortunately, where
> before I had everything passed back as text strings now things are
> being passed back in their binary form.
>
> My question is
>
> How is the postgres date type stored in C?
> Is it an integer in seconds from a specific date?
>
> How would I convert it to a text string of the form 05-21-1998?
> (When I print it as an integer I get 841823536)
>
>
> Before I received that text string as a result of the PQgetvalue now I am
> getting the binary form and I can't find a reference on how to convert
> back and forth. If this is an FAQ could someone point me to the
> appropriate section?
>
> Thanks
>
> Patricia Wright
>
>
>

[---]
Neil D. Quiogue <neil(at)iphil(dot)net>
Manager - Technical Team
IPhil Communications Network, Inc.