This topic is locked

ODBC time with postgres in timestamp

1/23/2007 6:15:08 AM
ASPRunnerPro General questions
S
sergio.milanesi author

Hi all ,

I recently ecountered a strange problem, I defined a filed in Postgresql DB Ver. 8.1 as time , but when i retreive it with asprunner

it becames as a strange timestamp with the current day and then the time but I expected only time.
Example:

Insert 10:12:23

Insert 10:13:23

Insert 10:14:23
select ... 23/01/2007 10:12:23

select ... 23/01/2007 10:13:23

select ... 23/01/2007 10:14:23
I think it's a problem with the ODBC driver, do you know how I can workaround it ?
Thankyou all.

Regards
Sergio Milanesi

Sergey Kornilov admin 1/23/2007

Sergio,
try to set View as type of this field to Time