Could someone help me with the most efficient way to update a date field.
-- David Portas SQL Server MVP -- DATETIME / SMALLDATETIME columns always contain both date and time.
The problem is caused by time precision in SQL Server.
You'll find that SQL Server cannot process Date Time values with millisecond accuracy.
Use the format 'YYYYMMDD' (no spaces) to define the date value. For example: UPDATE Your Table SET date_col = '20041122' WHERE ...
You can format the value without the time for display and printing purposes.