Sql sintax : get beginning of the month

February 13, 2009 at 7:20 am | Posted in cOdiNGkU | Leave a comment

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