Re: timestamp as varchar(23)

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: timestamp as varchar(23)
Дата
Msg-id 47B388D5.5040007@tpf.co.jp
обсуждение исходный текст
Ответ на timestamp as varchar(23)  ("Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com>)
Ответы Re: timestamp as varchar(23)  ("Zubkovsky, Sergey" <Sergey.Zubkovsky@transas.com>)
Список 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


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Zubkovsky, Sergey"
Дата:
Сообщение: timestamp as varchar(23)
Следующее
От: "Zubkovsky, Sergey"
Дата:
Сообщение: Re: timestamp as varchar(23)