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

a question of TIME

From: Gérald de Roany <g(dot)deroany(at)megalostudio(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: a question of TIME
Date: 2000-08-22 14:37:20
Message-ID: 39A29020.7B14F842@megalostudio.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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



pgsql-interfaces by date

Next:From: Jamie WalkerDate: 2000-08-22 15:06:04
Subject: Unattended install of Windows ODBC driver
Previous:From: John ThorhauerDate: 2000-08-22 14:34:03
Subject: odbc blob

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