walterddr opened a new issue, #9207:
URL: https://github.com/apache/pinot/issues/9207
there are many ANSI SQL standard date time functions that we should support
`DateTimeFunction` already support many of these implementations but the
semantics are different thus it is good to support the standardized ANSI
function format:
- `{fn YEAR(date)}`, `{fn MONTH(date)}`, ...
- `DATE(string)`, Equivalent to `CAST(string AS DATE)`
- `{fn NOW()}`
- `TIMESTAMPADD(timeUnit, integer, datetime)`
- `TIMESTAMPDIFF(timeUnit, datetime, datetime2)`
- `TO_DATE(string, format)`
- `TO_TIMESTAMP(string, format)`
- `INTERVAL timeWithUnit [ TO timeWithUnit ]`
we might also consider supporting some other non SQL standard such as:
- `DATE_ADD(<granularity>, <value>)` or `DATEADD` in mysql/presto/sqlserver
- `TO_UNIXTIME` / `FROM_UNIXTIME`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
