SQL query to extract all date functions from timestamp in Big Query

SELECT *, CONCAT(CAST(EXTRACT(YEAR FROM DATE (date)) AS STRING),”-”,CAST(EXTRACT(MONTH FROM DATE (date)) AS STRING)) AS Year_Month, FORMAT_DATETIME(‘%B’, DATETIME (date)) AS Month, EXTRACT(DAY FROM date) AS Day, EXTRACT(DAYOFWEEK FROM date) AS Dayofweek, FORMAT_DATETIME(“%b-%d-%Y”, DATETIME (date)) AS DATENAME FROM `compviz-348315.Tables.Checkin` LIMIT 1000;