Received: from lafontaine.cybercable.fr (lafontaine.cybercable.fr [212.198.0.202]) by hub.org (8.10.1/8.10.1) with SMTP id e7MEb5T80569 for ; Tue, 22 Aug 2000 10:37:05 -0400 (EDT) Received: (qmail 73070 invoked from network); 22 Aug 2000 14:37:02 -0000 Received: from r17m208.cybercable.tm.fr (HELO megalostudio.com) ([195.132.17.208]) (envelope-sender ) by lafontaine.cybercable.fr (qmail-ldap-1.03) with SMTP for ; 22 Aug 2000 14:37:02 -0000 Message-ID: <39A29020.7B14F842@megalostudio.com> Date: Tue, 22 Aug 2000 16:37:20 +0200 From: =?iso-8859-1?Q?G=E9rald?= de Roany Reply-To: g.deroany@megalostudio.com Organization: MegaloStudio Interactive X-Mailer: Mozilla 4.73 [en] (Windows NT 5.0; U) X-Accept-Language: fr,fr-FR,en,en-GB,en-US MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: a question of TIME Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id e7MEb6T80575 X-Archive-Number: 200008/124 Helo, I am using the driver psqlodbc 6.50.0000 under Win 2000 to "link" with postgreSQL 7.0.2 under Linux (Corel Linux v1.1 in fact). I have a table with a column of type TIME. The table was created with pgaccess. Updating this column is done with MS ASP / IIS and works fine. Viewing this column is strange : I get the current date of the HTTP server followed by a space and followed by the time value that was stored. Under psql and pgaccess everything look fine so I guess ODBC ... With a column of type TIMESTAMP everything's OK. pleaaase what's wrong ? Sincerely, -- Cordialement, Gérald de Roany MegaloStudio interactive - 04.50.08.08.80 - http://www.megalostudio.com