FUNCTION_NOT_FOUND: line 1:8: Function 'dateadd' not registered

Question

I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would be greatly appreciated. Thank you.

Leo K · Answer

If you're using the latest version of the Athena query engine, it uses Trino underneath, and the function is `date_add` (with an underscore): https://trino.io/docs/current/functions/datetime.html#date_add

You'll find links to all the functions supported by Athena's different versions in documentation:
https://docs.aws.amazon.com/athena/latest/ug/functions.html

FUNCTION_NOT_FOUND: line 1:8: Function 'dateadd' not registered

Contenido relevante