Page 1 of 1

Date field dialect 1 to 3

Posted: Thu 13 May 2010 00:06
by kstantonnw
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

Posted: Thu 13 May 2010 08:40
by Dimon
The problem is that SQL dialect 1 doesn't support the DATE datatype. To use this datatype use SQLDialect 3.