I have this Date Field in my table in DATETIME datatype and I would like to update the year with 2008 of the entire table.
I tried this but it did not work
where RecCreateDate is not null
It gave an Error.
Could you please give me a correct SQL statement for this