Hi @rc12, sorry for the confusion. I guess this is because you didn’t enable the new SQL engine for this date function and interval type support: GitHub - opendistro-for-elasticsearch/sql: 🔍 Open Distro SQL Plugin. This would be avoided once this new engine released later and enabled by default. Thanks!