CODE EXAMPLE FOR SQL

convert db timestamp to date

select from_unixtime(YourColumnName, '%Y') from yourTableName;