timestamp as varchar(23)

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: timestamp as varchar(23)
Date: 2008-02-12 12:32:36
Message-ID: 528853D3C5ED2C4AA8990B504BA7FB850106DEFB@sol.transas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2008-02-14 00:18:29 Re: timestamp as varchar(23)
Previous Message Hiroshi Inoue 2008-02-08 17:24:32 Re: SQLGetDiagRec, sqlstate returned?