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

Re: timestamp as varchar(23)

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: timestamp as varchar(23)
Date: 2008-02-14 12:58:48
Message-ID: 528853D3C5ED2C4AA8990B504BA7FB850106DEFE@sol.transas.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Yes, it works now!
I hope that the fixed driver will be released ASAP.
Thank you.

-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp] 
Sent: Thursday, February 14, 2008 3:18 AM
To: Zubkovsky, Sergey
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] timestamp as varchar(23)

Zubkovsky, Sergey wrote:
> Hi,
> 
> I'm trying to get some "timestamp without time zone" column's value as
a 
> varchar(23) value.
> 
> The SQLBindCol() function is used for this purpose in my C++ app.
> 
> However the result string doesn't contain milliseconds part at all
while 
> the real column's value contains it ('2007-12-23 10:00:01.123' for 
> example).
> 
> After SQLFetch() the result's buffer contains '2007-12-23 10:00:01'
only.

could you try the driver on testing for 8.030101 at
	http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: SQL Maestro TeamDate: 2008-02-15 06:06:58
Subject: AnySQL Maestro released
Previous:From: Hiroshi InoueDate: 2008-02-14 00:18:29
Subject: Re: timestamp as varchar(23)

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