>SQLServer 2000
>
>About 100 records had the month in a datetime field set wrong. I need to set them back but only the month portion in a datetime field. For example:
>
>SQL DATE: 0807171234
>Correct Date: 0806171234
>
>Any ideas on how to change only the month portion of sql datetime field and then specifiy which month?
Simple. Check DATE functions in SQL, there is a way to add/substract months.
http://msdn.microsoft.com/en-us/library/aa258267(SQL.80).aspxDATEADD ( mm, number, date )
If it's not broken, fix it until it is.
My Blog