Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 27 Dec 2005 20:53:51 +0200
- Message-id: <20051227185351.GA546@alamut> <text/plain>
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:
libpq_binary_date.c
Description: Text document
- References:
- Convertion of date/time binary format to text format
- From: Mavinakuli, Prasanna (STSD)
- Convertion of date/time binary format to text format
- Prev by Date: Fwd: [pgsql-tr-genel] oledb problem
- Next by Date: PQfformat() and Composite Formatted Results
- Previous by thread: Convertion of date/time binary format to text format
- Next by thread: Fwd: [pgsql-tr-genel] oledb problem
- Indexes: