Hi Ivan, the datatype "date" was introduced with SQL Server 2008. Before that, there was only "datetime". However empire-db has internally always stripped the time portion off, if you used the DataType Date.
I guess nobody has yet felt the need to update the driver class so that it allows a choice whether to use the new data types in DLL generation. You can do that if you like. I recommend that there is a property on the driver class that allows ot set the SQL-Server-Version and then generates the DDL accordingly. Regards, Rainer > from: Ivan Nemeth [mailto:[email protected]] > to: [email protected] > Subject: MSSQL DDL for DATE column > > Hi Rainer, > > if I define a column with DataType.DATA, in the resulting MSSQL DDL the SQL > type is DATETIME, not DATE. Is there any reason for this? > > Regards, > Ivan
