There is no such function in Calcite. Feel free to log a JIRA case to add a LAST_DAY function. Contributions welcome, of course.
You could do it using a SQL expression. Given a date d, you could add a month, then subtract the day of the month (using EXTRACT). For example, start with Aug 21st; add a month becomes Sep 21st; subtract 21 days becomes Aug 31st. Julian > On Aug 19, 2017, at 8:28 AM, [email protected] wrote: > > Hi, > > > What functions can be used to calculate the date of the end of the month in > calcite? > > Like oracle LAST_DAY function > > > > > > [email protected]
