BigQuery - Get Last Date time Of Month

Get the last date time to the second of the month to the second for the current date.

e.g.
For the date '2026-04-22' it would return '2026-04-30 23:59:59'

SELECT
  DATETIME_ADD(DATETIME(LAST_DAY(CURRENT_DATE(), MONTH)), INTERVAL 86399 SECOND)

See Also:
Big Query Get Last Day of The Month
Big Query Get First Day of The Month