Now have this kind of circumstance:
Data source if the ACCESS, get the date type field length Len:=Query. You. The Fields [I] DefinedSize; Len is equal to 8 bytes;
Data source if it is a SQL SERVER, get the date type field length Len:=Query. You. The Fields [I] DefinedSize; Len is equal to 16 bytes;
Want to ask what is what reason?

CodePudding user response:

8 it is essentially a datetime type

CodePudding user response:

Should be Long datetime (date) and Short datetime (Short date) difference

CodePudding user response:

ACCESS, the type of date field length, presently version 8 bytes; In the future high version may also want to 16 bytes,
SQL SERVER, date type field length, 8 byte 32 (2005); 64 (2008) 16 bytes;