Thread: ODBC Driver doesn't return fractional timestamp

ODBC Driver doesn't return fractional timestamp

From

"Florian Mader"

Date:

20 September 2002, 09:57:55

Hello,
I am Using PostgreSQL 7.2.2 and Windows ODBC Driver 7.02.00.02 If I use
psql directly select now() returns  now
-----------------------------
 2002-09-19 09:39:05.6897+02
(1 row)
a Timestamp with Fractions.
But if I use the ODBC Driver it doesn't return a fractional timestamp
 now
-------------------
2002-09-19 09:40:53

1 Row(s) affected

Does anybody know this problem and how to solve it? Doesn't my ODBC
Driver support fractional timestamps? Is there a newer Version? TIA
Florian

Re: ODBC Driver doesn't return fractional timestamp

From

"Hiroshi Inoue"

Date:

21 September 2002, 15:44:27

> -----Original Message-----
> From: Florian Mader
>
> Hello,
> I am Using PostgreSQL 7.2.2 and Windows ODBC Driver 7.02.00.02 If I use
> psql directly select now() returns  now
> -----------------------------
>  2002-09-19 09:39:05.6897+02
> (1 row)
> a Timestamp with Fractions.
> But if I use the ODBC Driver it doesn't return a fractional timestamp
>  now
> -------------------
> 2002-09-19 09:40:53
>
> 1 Row(s) affected

What kind of software are you using ?
The ODBC driver itself doesn't return the result
using the above format.

regards,
Hiroshi Inoue