Answers for "sql timestamp to decimal"

sql timestamp to date

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

sql convert to integer from decimal

-- CAST Syntax:  
CAST ( expression AS data_type [ ( length ) ] )  
  
-- CONVERT Syntax:  
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )