>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?
SELECT LEFT(Field,2)+RIGHT('00'+CONVERT(varchar(2),CAST(SUBSTRING(Field,3,2) as int)-1),2)+SUBSTRING(Field,5,10) As Test
FROM YourTable
not tested.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.