CODE EXAMPLE FOR SQL

how to extract only year and month from date in sql

SELECT FORMAT(<your-date-field>,"YYYY-MM") AS year-date FROM <your-table>