| 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: | Whole Thread | Raw Message | 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) ? |