ESS data types for MS SQL

[IdealData]

The FM knowledge base shows that SQL Server doesn't have a corresponding entry for DATE or TIME fields (all other variants of SQL do, however!)

So, how do I handle the SQL field if I only have a date, like a transaction date, and I want to update the SQL field.

Conversely, when I read the SQL field will I only get the date part back into my transaction date?

Will I need to redefine my transaction date to be an FM Timestamp.

If any one can give a "heads up" on similar items then that would be great.