Reported By: Steve Kellock Reported On: 10/29/2001 For: Version 3.03 Build 1
# 930Date/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");
ResolutionFixed Problem on 10/31/2001 in version 3.04 build 1