Firebird and data fields – porting issues from BDE

No’am Newman wrote again about his Bde to Firebird date migration issues:

In continuation of my previous post about problems of inserting/update date fields in FB databases, I did a little poking around and eventually – by trial and error – found the correct syntax:
update data
set datefield = ’01/01/2008′
where id = 1;