get the first day of the current month

SELECT CURDATE() - (CAST(RIGHT(LEFT(CAST(CURDATE() AS varchar(10)), 5),2) AS int) - 1)
FROM pub.PM_Company