Skip site navigation (1) Skip section navigation (2)

Re: ODBC Driver doesn't return fractional timestamp

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Florian Mader" <florian_mader(at)gmx(dot)net>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC Driver doesn't return fractional timestamp
Date: 2002-09-21 16:44:33
Message-ID: EKEJJICOHDIEMGPNIFIJEECMJDAA.Inoue@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
> -----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

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-09-21 16:44:47
Subject: Re: datetime and ODBC driver
Previous:From: Michael MeskesDate: 2002-09-20 19:26:01
Subject: [s.hetze@linux-ag.de: PostgreSQL integration Visual Basic, SQLProcedureColumns]

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group