Обсуждение: timestamp as varchar(23)
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.
The same program works fine with a MSSQLServer database so I cannot suppose that there is something wrong in my app.
OS: WinXP SP2
"PostgreSQL 8.3.0, compiled by Visual C++ build 1400"
ODBC Driver: PostgreSQL Unicode 08.03.01.00
Additional connection string settings:
ByteaAsLongVarbinary=1; TextAsLongVarchar=1; MaxVarcharSize=8000; BoolsAsChar=0; BI=-5; LFConversion=0; LowerCaseIdentifier=0;
How can I get “milliseconds part” in this case?
Thank you.
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
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