Icon View Incident Report

Serious Serious
Reported By: Steve Kellock
Reported On: 10/29/2001
For: Version 3.03 Build 1
# 930 Date/Time Values not Being Interpreted Properly When Containing 12:00 AM Time Values

The following SQL causes the incorrect date and time to be inserted into the table. When looking in the database the value is "4/2/1999 12:00:42 PM" (notice the AM/PM switch). If I leave off the seconds token it works properly. If I tried the original command, but moved the date forward 1 hour, it works properly too. It seems as if for the hour of 12:00AM-12:59AM, if you add the seconds token, DBISAM will convert it to PM by mistake.

INSERT INTO packages (clientID, LastModified) VALUES (1, 
"1999-04-02 12:00:42 AM");



Resolution Resolution
Fixed Problem on 10/31/2001 in version 3.04 build 1
Image