Re: Convertion of date/time binary format to text format - Mailing list pgsql-interfaces

From Volkan YAZICI
Subject Re: Convertion of date/time binary format to text format
Date
Msg-id 20051227185351.GA546@alamut
Whole thread Raw
In response to Convertion of date/time binary format to text format  ("Mavinakuli, Prasanna (STSD)" <prasanna.b-m@hp.com>)
List 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

pgsql-interfaces by date:

Previous
From: "Mavinakuli, Prasanna (STSD)"
Date:
Subject: Convertion of date/time binary format to text format
Next
From: Volkan YAZICI
Date:
Subject: PQfformat() and Composite Formatted Results