• The sooner we stop using datetime the better. We now have Date & Time Data Types and DateTime2.

    It's fairly straight forward: Dates and Times should be stored as such. If a Timestamp is required then use Datetime2 with its correct level of accuracy.