1 Answer
- Newest
- Most votes
- Most comments
2
Your arguments are in incorrect order. Please pass the integer value as 2nd parameter as shown below:
select cast (add_months(cast(public.date_column as date),1) as date)
from public.table
where date_column <= '2023-02-28' limit 10;
Relevant content
- asked 7 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 5 months ago
Thanks, The error message made me think the function was not found but the parameter order was incorrect.