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 day from particualar date

Query to get only day from particualar date
select day(datecolumnname)as day from tablename