Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: timestamp as varchar(23)
- From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
- To: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
- Cc: pgsql-odbc(at)postgresql(dot)org
- Subject: Re: timestamp as varchar(23)
- Date: Thu, 14 Feb 2008 09:18:29 +0900
- Message-id: <47B388D5.5040007@tpf.co.jp> <text/plain>
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
- Follow-Ups:
- Re: timestamp as varchar(23)
- From: Zubkovsky, Sergey
- Re: timestamp as varchar(23)
- References:
- timestamp as varchar(23)
- From: Zubkovsky, Sergey
- timestamp as varchar(23)
- Prev by Date: timestamp as varchar(23)
- Next by Date: Re: timestamp as varchar(23)
- Previous by thread: timestamp as varchar(23)
- Next by thread: Re: timestamp as varchar(23)
- Indexes: