SQL: Introduce SQL TIME type #38174
Description
ES SQL should have DataType.TIME added to describe a TIME only type to conform to ANSI SQL.
Being a new time type, all date-related functionalities would need to take it into account:
a. grouping and histograms
The latter in particular should have the max interval of 1 day
b. date-time functions
As most work on the date component this is mainly a validation task
c. date-time math
Adding or extracting an interval. Worth looking into whether DATETIME-TIME