SQL: support for nanoseconds precision for SQL INTERVALs #38402
Description
The INTERVALs in SQL have currently a precision of milliseconds and three digits after . (dot). Elasticsearch has just introduced a new data type representing a date with nanoseconds precision and for 7.0 is aiming to migrate from joda time to java time. When support for this will be fully in place, we should consider increasing the precision for intervals to nanoseconds.