BigQuery - Get First Day Of Month
Get the first day of the month for the current date.
SELECT
DATE_TRUNC(CURRENT_DATE(), MONTH)
See Also:
Big Query Get Last Day of The Month
Big Query Get Last DateTime of The Month
Select a result to preview
Get the first day of the month for the current date.
SELECT
DATE_TRUNC(CURRENT_DATE(), MONTH)
See Also:
Big Query Get Last Day of The Month
Big Query Get Last DateTime of The Month