_first_of_month
Returns a datetime that is the first day of the month represented by "timestamp_expression".
Syntax
_first_of_month ( timestamp_expression )Example 1
_first_of_month ( 2009-05-04 00:00:00.000 )Result
Returns 2009-05-01 00:00:00.000
Example 2
_first_of_month (current_date)Result
Returns Jul 1, 2009 if the current date is July 30, 2009.