Wed, 18 Jun 1902 08:00:00 GMT
date formats with interbase 5.3
when adding records with date format 'MM/dd/yyyy' i get a string truncation error. it seems that the date format must be 'dd/MM/yyyy'. i could manipulate the date string to get it into the 'dd/MM/yyyy' format, but when using an IBSql component and ParamByName('').AsString when passing it just a string i get an error as well. if i set the ParamByName('').AsString equal to the FormatDateTime function it works if the Date format is 'dd/MM/yyyy'. i need to do more fiddling i suppose. the question is how do i add a date when the date format is 'MM/dd/yyyy' ?
|