Search code examples
intervalsdurationtdengine

INTERVAL duration literals in TDEngine

I am not able to find duration literals used by INTERVAL keyword in TDEngine. E.g. select count(*) from mytable interval(1m); works for 1-minute intervals, but I don't know what letter should be used for 1-month interval. I would like to know all possible duration intervals available.

Solution

  • Let's see source code. It seems TDEngine supports these duration intervals:

    /*
 * b - nanoseconds;
 * u - microseconds;
 * a - Millionseconds
 * s - Seconds
 * m - Minutes
 * h - Hours
 * d - Days (24 hours)
 * w - Weeks (7 days)
 * n - Months (30 days)
 * y - Years (365 days)
 */