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: 2008-02-14 00:18:29
Message-ID: 47B388D5.5040007@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Zubkovsky, Sergey 2008-02-14 12:58:48 Re: timestamp as varchar(23)
Previous Message Zubkovsky, Sergey 2008-02-12 12:32:36 timestamp as varchar(23)