Re: Convertion of date/time binary format to text format

From: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
To: "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Convertion of date/time binary format to text format
Date: 2005-12-27 18:53:51
Message-ID: 20051227185351.GA546@alamut
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-interfaces

On Dec 23 12:25, Mavinakuli, Prasanna (STSD) wrote:
> So how can I get the ASCII format/Text format from that binary
> format.
>
> Please get me the steps to convert timestamp column which is of
> binary mode to TEXT/ASCII mode

I attached an example program which answers your question. Hope
this helps.

(I skipped byte order conversions in my example for simplicity. Don't
forget 'em in your own program for portability.)

Regards.

--
"We are the middle children of history, raised by television to believe
that someday we'll be millionaires and movie stars and rock stars, but
we won't. And we're just learning this fact," Tyler said. "So don't
fuck with us."

Attachment Content-Type Size
libpq_binary_date.c text/plain 1.2 KB

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Volkan YAZICI 2005-12-30 23:37:10 PQfformat() and Composite Formatted Results
Previous Message Volkan YAZICI 2005-12-23 14:21:51 Fwd: [pgsql-tr-genel] oledb problem