_last_of_month
Returns a timestamp with time zone (as a string) that is the last day of the month represented by "string_expression", where "string_expression" is a timestamp with time zone.
Syntax
_last_of_month ( string_expression )Example 1
# _last_of_month ( '2005-11-11 12:00:00.000-05:00' ) #Result
2005-11-30 12:00:00.000000000-05:00
Example 2
# timestampMask ( _last_of_month ( '2005-11-11 12:00:00.000-05:00' ) ,
'yyyy-mm-dd' ) #Result
2005-11-30