SQL Query to Rename Column Name in SQL Server-Query to change Column Name in SQL SERVER

Query to change Column Name in SQL SERVER

sp_rename 'Tablename.old fieldname', 'new field name'

sp_rename 'xyz.aaa','bbb'

Query to get only year from particular date

Query to get only year from particular date
select year(datecolumnname)as year from tablename

query to get system date

query to get system date and time using sqlserver

select getdate()