Calculate End date of current, previous or next month

CrateDB SQL
1

Hi

Based on the current date I would like figure out what is the end date of the previous, current or the next month. Is it possible using scalar or other means in CrateDB?

Thanks,
Ritwick

2

Hi @ritwick,

Did you already check out this article on scalar functions?: https://crate.io/docs/crate/reference/en/latest/general/builtins/scalar.html

Best Roman