Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread 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."

In response to

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group