Re: timestamp as varchar(23) - Mailing list pgsql-odbc

From Zubkovsky, Sergey
Subject Re: timestamp as varchar(23)
Date
Msg-id 528853D3C5ED2C4AA8990B504BA7FB850106DEFE@sol.transas.com
Whole thread Raw
In response to Re: timestamp as varchar(23)  (Hiroshi Inoue <inoue@tpf.co.jp>)
List 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@tpf.co.jp]
Sent: Thursday, February 14, 2008 3:18 AM
To: Zubkovsky, Sergey
Cc: pgsql-odbc@postgresql.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


pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: timestamp as varchar(23)
Next
From: "SQL Maestro Team"
Date:
Subject: AnySQL Maestro released