>>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).aspx>
>DATEADD ( mm, number, date )
Great, need it right now.
If it's not broken, fix it until it is.
My Blog