How to rename column in Redshift database

Use the below command to rename column of a Redshift table.

alter table tablename                      
rename column columnname to new_columnname;
See also  How to get current date, day, month, year in Redshift database