Can we have InfluxQL support DatePart which is supported in almost all SQL engines? The use case is to analyze long term trend over a wide time scale, but only part of the range. Example use cases.

When grouping date values at the query level, you can rely on the DatePart () function. This function evaluates a date value and returns a specific component, so you can use it to group by month ...

Isn't there an easy way to get a 2-digit day from a SQL query?SELECT datepart(dd, getDate()); will return "1" for July 1st. How can I get it to return "01";Best I can come up with is:select RIGHT ...