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

Convertion of date/time binary format to text format

From: "Mavinakuli, Prasanna (STSD)" <prasanna(dot)b-m(at)hp(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: Convertion of date/time binary format to text format
Date: 2005-12-23 06:55:10
Message-ID: E84C4F56CA80174D8834825116CF247F01BFA23D@bgeexc05.asiapacific.cpqcorp.net (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

I am getting data in binary mode..(schema contains bytea so we need to
get result in binary format)

But we have timestamp in schema.this would be also in 
Binary format.

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****..


Thanking You,
Prasanna.

Responses

pgsql-interfaces by date

Next:From: Volkan YAZICIDate: 2005-12-23 14:21:51
Subject: Fwd: [pgsql-tr-genel] oledb problem
Previous:From: Joshua D. DrakeDate: 2005-12-21 21:08:47
Subject: Re: Libpq++ interface for postgres 8.1

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