timestamp to date sql code example
Example: sql timestamp to date
date_format(from_unix_time(`my_date`), '%e %b %Y') AS 'date_formatted'
cast(my_date as DATE)
date_format(from_unix_time(`my_date`), '%e %b %Y') AS 'date_formatted'
cast(my_date as DATE)