1. It is my impression that the SQL Server datetime2 datatype is intended to mirror the .NET datetime datatype.
It does extend the Gregorian date back to 01-01-0001 (ignoring the conversions to and from Julian).
2. At some point in time the smalldatetime will be deprecated (and eventually eliminated). There will be no use for it as memory and storage costs decrease.
Rand
|