If you use the version of MSVCRT.DLL included with InterBase 5.6 on Windows NT or Windows 95, when you insert NOW into a date field the time will be off by 1 hour for dates in daylight savings time before April 8. In the year 2001, the problem occurs April 1 - 7. In the year 2002 it occurs on April 7th only. Example:
create table mytable (f1 date)
insert into mytable values ('now')
To resolve the problem obtain a later version of MSVCRT.DLL. It is included with anything you get from Microsoft, for example Office or Internet Explorer, and many other products. It may also be downloaded from Microsoft at http://support.microsoft.com/support/kb/articles/Q197/2/98.ASP . For additional information on the problem see Microsoft Knowledgebase Article Q214661
Note that this problem does not effect InterBase 6 or when using Windows 2000/98/ME.
Last Modified: 04-APR-01