SQL Server 2008: Get date part from datetime2
Can't you just do a
ALTER TABLE dbo.YourTableADD DateOnly AS CAST(YourDate AS DATE) PERSISTEDThe CAST(... AS DATE) turns your datetime2 column into a "date-only", and it seems to be deterministic enough to be used in a persisted, computed column definition ...