Description
The fastest way to get most functions to work with date nanos at all will be to cast them to a type we already support well. We'll also need a way to cast back to date nanos. There are three functions wrapped up into this ticket, because I think we'll need all three at once to sensibly test any of them. I might be wrong about that though, in which case we could break this down further.
Description
The fastest way to get most functions to work with date nanos at all will be to cast them to a type we already support well. We'll also need a way to cast back to date nanos. There are three functions wrapped up into this ticket, because I think we'll need all three at once to sensibly test any of them. I might be wrong about that though, in which case we could break this down further.
TO_DATETIMEshould accept a date nanos and return a millisecond resolution time (NOTE: We need to have a rounding convention here)TO_LONGshould accept a date nanos and return the same value as a longTO_STRINGshould accept a date nanos and return a formatted string. We have [ESQL] Support passing Date_Nanos to Date_Format function #109994 for full formatting on date nanos, but providing basicTO_STRINGsupport early will help with debugging.