SQL - How to extract month from year

In this example dob is the database column and we would like to extract the month from date dob '2010-01-01'.

We can use the SQL function month()

month(dob) = 01

Last Updated: June 3, 2020