| 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 | Resend email |
| 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 |
| 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 |