Date field dialect 1 to 3

kstantonnw · Post by **kstantonnw** » Thu 13 May 2010 00:06

Greetings,
I have a two customers of mine on a dialect 1 database.
It appears date fields are different in the two as the instantiated fields are different: 1 is a DATETIME field type (in delphi) and 3 is a DATE field.
Is there a clean way to handle this? I know, I have to migrate my last 2 dialect 1 customers to dialect 3 - in process.
Thanks,
Kevin

Dimon · Post by **Dimon** » Thu 13 May 2010 08:40

The problem is that SQL dialect 1 doesn't support the DATE datatype. To use this datatype use SQLDialect 3.