Opened 16 years ago

Closed 16 years ago

#404 closed defect (fixed)

ODBC provider - Incorrect DateTime insert (seconds are truncated)

Reported by: danstoica Owned by: danstoica
Priority: major Milestone: 3.4.0
Component: ODBC Provider Version: 3.2.0
Severity: 3 Keywords:
Cc: External ID: 1127137

Description

The string representing the datetime is not correctly formatted on insert and the 'seconds' field is truncated. Example:

Insert 10/3/2008 1:41:55. Check the feature it in and on read the value will come back as 10/3/2008 1:41:00

The error is in FdoRdbmsOdbcConnection::FdoToDbiTime() where the fact 'seconds' is a float is ignored and it is treated as an int instead.

Change History (2)

comment:1 by danstoica, 16 years ago

Also, the logic in the same function is ignoring the case when only Time is present. In such case the year is flagged as -1. The result is failure on insert into database.

comment:2 by danstoica, 16 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.