I have been wrestling with the MSSQL datetime fields and I still cannot get good results.
Upon reconnecting to the MSSQL database tables to refresh the *.INT files I experience this behavior in the runtime:
Moving a VDF datetime variable value into the MSSQL datetime fields truncates the value to the date portion only.
If I use the DBBuilder to "reset" the data type of the field, I start having "Invalid Cast" errors on saves.
The Studio shows the DF_FIELD_NATIVE_TYPE as SQL_TYPE_TIMESTAMP not SQL_DATETIME!
Is this a bug in the CLI? I will try creating a restucture program to force this attribute to "SQL_DATETIME" to see if the time issue resolves.
Any help appreciated!