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 , 16 years ago
comment:2 by , 16 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
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.