dd-willgan opened a new issue, #13610: URL: https://github.com/apache/pinot/issues/13610
The `TIMESTAMP` data type introduces convenience with a human readable value while still maintaining performance with an underlying `LONG` representation. Currently, however, string filters on `TIMESTAMP` columns requires specifying the filter like ``` WHERE ts >= '2024-07-12 00:00:00' AND ts < '2024-07-13 00:00:00' ``` This can make it inconvenient for common patterns such as filtering on date. A more convenient way (which you can do in tools such as Snowflake) is write the filter as ``` WHERE ts >= '2024-07-12' and ts < '2024-07-13' ``` -- 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]
