Last day of the month

Hi,
I need to get the last day of the month of a given date.

Normally in Pl/SQL I would use this function LAST_DAY( sysdate)

This is th result I need

  • Input: 07/08/2021
  • Output: 31/08/2021

How could I get it in Redash?

1 Like