From: | "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com> |
---|---|
To: | <pgsql-docs(at)postgresql(dot)org> |
Subject: | timestamp as varchar(23) |
Date: | 2008-02-12 12:02:41 |
Message-ID: | 528853D3C5ED2C4AA8990B504BA7FB850106DEFA@sol.transas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-02-13 22:44:57 | Migration section added |
Previous Message | Steve Atkins | 2008-02-11 23:16:40 | Missing docs for "FM" in to_char(numeric) ? |