Answers for "sql date format from timestamp"

sql timestamp to date

date_format(from_unix_time(`my_date`), '%e %b %Y') AS 'date_formatted'
cast(my_date as DATE)

Posted by: Guest on April-25-2021

sql server format datetime to short date

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Posted by: Guest on June-17-2020

Code answers related to "sql date format from timestamp"