to get the beginning of the month you can try this simple sintax :
select cast(date_trunc(‘month’, now())as date)
the result :
2009-02-01
to get the beginning of the month you can try this simple sintax :
select cast(date_trunc(‘month’, now())as date)
the result :
2009-02-01