#4720

Committed 08 Sep 2025 08:43AM UTC coverage: 58.139% (-0.6%) from 58.762%

Build # #4720

Build Type

push

travis-ci

Committed by

web-flow

Commit Message

Merge pull request #32881 from taosdata/enh/add-new-windows-ci

fix(ci): update workflow reference to use new Windows CI YAML

Run Details

133181 of 292179 branches covered (45.58%)

Branch coverage included in aggregate %.

201691 of 283811 relevant lines covered (71.07%)

5442780.71 hits per line

Source File
Press 'n' to go to next uncovered line, 'b' for previous

76.56

/source/common/src/ttime.c

/*
 * Copyright (c) 2019 TAOS Data, Inc. <jhtao@taosdata.com>
 *
 * This program is free software: you can use, redistribute, and/or modify
 * it under the terms of the GNU Affero General Public License, version 3
 * or later ("AGPL"), as published by the Free Software Foundation.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT
 * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
 * FITNESS FOR A PARTICULAR PURPOSE.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see <http://www.gnu.org/licenses/>.
 */

#ifdef DARWIN
#define _XOPEN_SOURCE
#else
#define _XOPEN_SOURCE 500
#endif

#define _BSD_SOURCE
#define _DEFAULT_SOURCE
#include "ttime.h"

#include "tlog.h"

static int32_t parseFraction(char* str, char** end, int32_t timePrec, int64_t* pFraction);
static int32_t parseTimeWithTz(const char* timestr, int64_t* time, int32_t timePrec, char delim);
static int32_t parseLocaltimeDst(char* timestr, int32_t len, int64_t* utime, int32_t timePrec, char delim, timezone_t tz);
static char*   forwardToTimeStringEnd(char* str);
static bool    checkTzPresent(const char* str, int32_t len);
static int32_t parseTimezone(char* str, int64_t* tzOffset);

int32_t taosParseTime(const char* timestr, int64_t* utime, int32_t len, int32_t timePrec, timezone_t tz) {
  /* parse datatime string in with tz */
  if (strnchr(timestr, 'T', len, false) != NULL) {
    if (checkTzPresent(timestr, len)) {
      return parseTimeWithTz(timestr, utime, timePrec, 'T');
    } else {
      return parseLocaltimeDst((char*)timestr, len, utime, timePrec, 'T', tz);
    }
  } else {
    if (checkTzPresent(timestr, len)) {
      return parseTimeWithTz(timestr, utime, timePrec, 0);
    } else {
      return parseLocaltimeDst((char*)timestr, len, utime, timePrec, 0, tz);
    }
  }
}

bool checkTzPresent(const char* str, int32_t len) {
  char*   seg = forwardToTimeStringEnd((char*)str);
  int32_t seg_len = len - (int32_t)(seg - str);

  char* c = &seg[seg_len - 1];
  for (int32_t i = 0; i < seg_len; ++i) {
    if (0 == *c) {
      break;
    }
    if (*c == 'Z' || *c == 'z' || *c == '+' || *c == '-') {
      return true;
    }
    c--;
  }

  return false;
}

char* forwardToTimeStringEnd(char* str) {
  int32_t i = 0;
  int32_t numOfSep = 0;

  while (str[i] != 0 && numOfSep < 2) {
    if (str[i++] == ':') {
      numOfSep++;
    }
  }

  while (str[i] >= '0' && str[i] <= '9') {
    i++;
  }

  return &str[i];
}

int32_t parseFraction(char* str, char** end, int32_t timePrec, int64_t* pFraction) {
  int32_t i = 0;
  int64_t fraction = 0;

  const int32_t MILLI_SEC_FRACTION_LEN = 3;
  const int32_t MICRO_SEC_FRACTION_LEN = 6;
  const int32_t NANO_SEC_FRACTION_LEN = 9;

  int32_t factor[9] = {1, 10, 100, 1000, 10000, 100000, 1000000, 10000000, 100000000};
  int32_t times = 1;

  while (str[i] >= '0' && str[i] <= '9') {
    i++;
  }

  int32_t totalLen = i;
  if (totalLen <= 0) {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  /* parse the fraction */
  if (timePrec == TSDB_TIME_PRECISION_MILLI) {
    /* only use the initial 3 bits */
    if (i >= MILLI_SEC_FRACTION_LEN) {
      i = MILLI_SEC_FRACTION_LEN;
    }

    times = MILLI_SEC_FRACTION_LEN - i;
  } else if (timePrec == TSDB_TIME_PRECISION_MICRO) {
    if (i >= MICRO_SEC_FRACTION_LEN) {
      i = MICRO_SEC_FRACTION_LEN;
    }
    times = MICRO_SEC_FRACTION_LEN - i;
  } else if (timePrec == TSDB_TIME_PRECISION_NANO) {
    if (i >= NANO_SEC_FRACTION_LEN) {
      i = NANO_SEC_FRACTION_LEN;
    }
    times = NANO_SEC_FRACTION_LEN - i;
  } else {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  fraction = strnatoi(str, i) * factor[times];
  *end = str + totalLen;
  *pFraction = fraction;

  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

#define PARSE(str,len,result) \
  if (len != 2) {\
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);\
  }\
  result = strnatoi(str, len);

int32_t parseTimezone(char* str, int64_t* tzOffset) {
  int64_t hour = 0;
  int64_t minute = 0;

  int32_t i = 0;
  if (str[i] != '+' && str[i] != '-') {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  i++;

  int32_t j = i;
  while (str[j]) {
    if ((str[j] >= '0' && str[j] <= '9') || str[j] == ':') {
      ++j;
      continue;
    }

    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  char* sep = strchr(&str[i], ':');
  if (sep != NULL) {
    int32_t hourSize = (int32_t)(sep - &str[i]);
    PARSE(&str[i], hourSize, hour);

    i += hourSize + 1;
    size_t minSize = strlen(&str[i]);
    PARSE(&str[i], minSize, minute);
  } else {
    size_t hourSize = strlen(&str[i]);
    if (hourSize > 2){
      hourSize = 2;
    }
    PARSE(&str[i], hourSize, hour)
    i += hourSize;
    size_t minSize = strlen(&str[i]);
    if (minSize > 0){
      PARSE(&str[i], minSize, minute);
    }
  }

  if (hour > 13 || hour < 0) {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }
  if (minute > 59 || minute < 0) {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  if (str[0] == '+') {
    *tzOffset = -(hour * 3600 + minute * 60);
  } else {
    *tzOffset = hour * 3600 + minute * 60;
  }

  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

int32_t offsetOfTimezone(char* tzStr, int64_t* offset) {
  if (tzStr && (tzStr[0] == 'z' || tzStr[0] == 'Z')) {
    *offset = 0;
    return TSDB_CODE_SUCCESS;
  }
  return parseTimezone(tzStr, offset);
}

/*
 * rfc3339 format:
 * 2013-04-12T15:52:01+08:00
 * 2013-04-12T15:52:01.123+08:00
 *
 * 2013-04-12T15:52:01Z
 * 2013-04-12T15:52:01.123Z
 *
 * iso-8601 format:
 * 2013-04-12T15:52:01+0800
 * 2013-04-12T15:52:01.123+0800
 */
int32_t parseTimeWithTz(const char* timestr, int64_t* time, int32_t timePrec, char delim) {
  int64_t factor = TSDB_TICK_PER_SECOND(timePrec);
  int64_t tzOffset = 0;

  struct tm tm = {0};

  char* str;
  if (delim == 'T') {
    str = taosStrpTime(timestr, "%Y-%m-%dT%H:%M:%S", &tm);
  } else if (delim == 0) {
    str = taosStrpTime(timestr, "%Y-%m-%d %H:%M:%S", &tm);
  } else {
    str = NULL;
  }

  if (str == NULL) {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

/* mktime will be affected by TZ, set by using taos_options */
#if defined(WINDOWS) || defined(TD_ASTRA) 
  int64_t seconds = user_mktime64(tm.tm_year + 1900, tm.tm_mon + 1, tm.tm_mday, tm.tm_hour, tm.tm_min, tm.tm_sec, 0);
  // int64_t seconds = gmtime(&tm);
#else
  int64_t seconds = taosTimeGm(&tm);
  if (seconds == -1){
    TAOS_RETURN(TAOS_SYSTEM_ERROR(ERRNO));
  }
#endif

  int64_t fraction = 0;
  str = forwardToTimeStringEnd((char*)timestr);

  if ((str[0] == 'Z' || str[0] == 'z') && str[1] == '\0') {
    /* utc time, no millisecond, return directly*/
    *time = seconds * factor;
  } else if (str[0] == '.') {
    str += 1;
    TAOS_CHECK_RETURN(parseFraction(str, &str, timePrec, &fraction));

    *time = seconds * factor + fraction;

    char seg = str[0];
    if (seg != 'Z' && seg != 'z' && seg != '+' && seg != '-') {
      TAOS_RETURN(TSDB_CODE_INVALID_PARA);
    } else if ((seg == 'Z' || seg == 'z') && str[1] != '\0') {
      TAOS_RETURN(TSDB_CODE_INVALID_PARA);
    } else if (seg == '+' || seg == '-') {
      // parse the timezone
      TAOS_CHECK_RETURN(parseTimezone(str, &tzOffset));

      *time += tzOffset * factor;
    }

  } else if (str[0] == '+' || str[0] == '-') {
    *time = seconds * factor + fraction;

    // parse the timezone
    TAOS_CHECK_RETURN(parseTimezone(str, &tzOffset));

    *time += tzOffset * factor;
  } else {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

static FORCE_INLINE bool validateTm(struct tm* pTm) {
  if (pTm == NULL) {
    return false;
  }

  int32_t dayOfMonth[12] = {31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31};

  int32_t leapYearMonthDay = 29;
  int32_t year = pTm->tm_year + 1900;
  bool    isLeapYear = ((year % 100) == 0) ? ((year % 400) == 0) : ((year % 4) == 0);

  if (isLeapYear && (pTm->tm_mon == 1)) {
    if (pTm->tm_mday > leapYearMonthDay) {
      return false;
    }
  } else {
    if (pTm->tm_mday > dayOfMonth[pTm->tm_mon]) {
      return false;
    }
  }

  return true;
}

int32_t parseLocaltimeDst(char* timestr, int32_t len, int64_t* utime, int32_t timePrec, char delim, timezone_t tz) {
  *utime = 0;
  struct tm tm = {0};
  tm.tm_isdst = -1;

  char* str;
  if (delim == 'T') {
    str = taosStrpTime(timestr, "%Y-%m-%dT%H:%M:%S", &tm);
  } else if (delim == 0) {
    str = taosStrpTime(timestr, "%Y-%m-%d %H:%M:%S", &tm);
  } else {
    str = NULL;
  }

  if (str == NULL || (((str - timestr) < len) && (*str != '.')) || !validateTm(&tm)) {
    // if parse failed, try "%Y-%m-%d" format
    str = taosStrpTime(timestr, "%Y-%m-%d", &tm);
    if (str == NULL || (((str - timestr) < len) && (*str != '.')) || !validateTm(&tm)) {
      TAOS_RETURN(TSDB_CODE_INVALID_PARA);
    }
  }

  int64_t seconds = taosMktime(&tm, tz);

  int64_t fraction = 0;
  if (*str == '.') {
    /* parse the second fraction part */
    TAOS_CHECK_RETURN(parseFraction(str + 1, &str, timePrec, &fraction));
  }

  *utime = TSDB_TICK_PER_SECOND(timePrec) * seconds + fraction;
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

char getPrecisionUnit(int32_t precision) {
  static char units[3] = {TIME_UNIT_MILLISECOND, TIME_UNIT_MICROSECOND, TIME_UNIT_NANOSECOND};
  switch (precision) {
    case TSDB_TIME_PRECISION_MILLI:
    case TSDB_TIME_PRECISION_MICRO:
    case TSDB_TIME_PRECISION_NANO:
      return units[precision];
    default:
      return 0;
  }
}

int64_t convertTimePrecision(int64_t utime, int32_t fromPrecision, int32_t toPrecision) {
  switch (fromPrecision) {
    case TSDB_TIME_PRECISION_MILLI: {
      switch (toPrecision) {
        case TSDB_TIME_PRECISION_MILLI:
          return utime;
        case TSDB_TIME_PRECISION_MICRO:
          if (utime > INT64_MAX / 1000) {
            return INT64_MAX;
          }
          return utime * 1000;
        case TSDB_TIME_PRECISION_NANO:
          if (utime > INT64_MAX / 1000000) {
            return INT64_MAX;
          }
          return utime * 1000000;
        default:
          return utime;
      }
    }  // end from milli
    case TSDB_TIME_PRECISION_MICRO: {
      switch (toPrecision) {
        case TSDB_TIME_PRECISION_MILLI:
          return utime / 1000;
        case TSDB_TIME_PRECISION_MICRO:
          return utime;
        case TSDB_TIME_PRECISION_NANO:
          if (utime > INT64_MAX / 1000) {
            return INT64_MAX;
          }
          return utime * 1000;
        default:
          return utime;
      }
    }  // end from micro
    case TSDB_TIME_PRECISION_NANO: {
      switch (toPrecision) {
        case TSDB_TIME_PRECISION_MILLI:
          return utime / 1000000;
        case TSDB_TIME_PRECISION_MICRO:
          return utime / 1000;
        case TSDB_TIME_PRECISION_NANO:
          return utime;
        default:
          return utime;
      }
    }  // end from nano
    default: {
      return utime;  // only to pass windows compilation
    }
  }  // end switch fromPrecision

  return utime;
}

// !!!!notice:there are precision problems, double lose precison if time is too large, for example:
// 1626006833631000000*1.0 = double = 1626006833631000064
// int64_t convertTimePrecision(int64_t time, int32_t fromPrecision, int32_t toPrecision) {
//  static double factors[3][3] = {{1., 1000., 1000000.}, {1.0 / 1000, 1., 1000.}, {1.0 / 1000000, 1.0 / 1000, 1.}};
//  ((double)time * factors[fromPrecision][toPrecision]);
//}

// !!!!notice: double lose precison if time is too large, for example: 1626006833631000000*1.0 = double =
// 1626006833631000064
int32_t convertTimeFromPrecisionToUnit(int64_t time, int32_t fromPrecision, char toUnit, int64_t* pRes) {
  if (fromPrecision != TSDB_TIME_PRECISION_MILLI && fromPrecision != TSDB_TIME_PRECISION_MICRO &&
      fromPrecision != TSDB_TIME_PRECISION_NANO) {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  int64_t factors[3] = {NANOSECOND_PER_MSEC, NANOSECOND_PER_USEC, 1};
  double  tmp = time;
  switch (toUnit) {
    case 's': {
      time /= (NANOSECOND_PER_SEC / factors[fromPrecision]);
      tmp = (double)time;
      break;
    }
    case 'm':
      time /= (NANOSECOND_PER_MINUTE / factors[fromPrecision]);
      tmp = (double)time;
      break;
    case 'h':
      time /= (NANOSECOND_PER_HOUR / factors[fromPrecision]);
      tmp = (double)time;
      break;
    case 'd':
      time /= (NANOSECOND_PER_DAY / factors[fromPrecision]);
      tmp = (double)time;
      break;
    case 'w':
      time /= (NANOSECOND_PER_WEEK / factors[fromPrecision]);
      tmp = (double)time;
      break;
    case 'a':
      time /= (NANOSECOND_PER_MSEC / factors[fromPrecision]);
      tmp = (double)time;
      break;
    case 'u':
      // the result of (NANOSECOND_PER_USEC/(double)factors[fromPrecision]) maybe a double
      switch (fromPrecision) {
        case TSDB_TIME_PRECISION_MILLI: {
          tmp *= 1000;
          time *= 1000;
          break;
        }
        case TSDB_TIME_PRECISION_MICRO: {
          time /= 1;
          tmp = (double)time;
          break;
        }
        case TSDB_TIME_PRECISION_NANO: {
          time /= 1000;
          tmp = (double)time;
          break;
        }
      }
      break;
    case 'b':
      tmp *= factors[fromPrecision];
      time *= factors[fromPrecision];
      break;
    default: {
      TAOS_RETURN(TSDB_CODE_INVALID_PARA);
    }
  }
  if (tmp >= (double)INT64_MAX) {
    *pRes = INT64_MAX;
  } else if (tmp <= (double)INT64_MIN) {
    *pRes = INT64_MIN;
  } else {
    *pRes = time;
  }

  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

int32_t convertStringToTimestamp(int16_t type, char* inputData, int64_t timePrec, int64_t* timeVal, timezone_t tz, void* charsetCxt) {
  int32_t charLen = varDataLen(inputData);
  char*   newColData;
  if (type == TSDB_DATA_TYPE_BINARY || type == TSDB_DATA_TYPE_VARBINARY) {
    newColData = taosMemoryCalloc(1, charLen + 1);
    if (NULL == newColData) {
      TAOS_RETURN(terrno);
    }
    (void)memcpy(newColData, varDataVal(inputData), charLen);
    int32_t ret = taosParseTime(newColData, timeVal, charLen, (int32_t)timePrec, tz);
    if (ret != TSDB_CODE_SUCCESS) {
      taosMemoryFree(newColData);
      TAOS_RETURN(TSDB_CODE_INVALID_TIMESTAMP);
    }
    taosMemoryFree(newColData);
  } else if (type == TSDB_DATA_TYPE_NCHAR) {
    newColData = taosMemoryCalloc(1, charLen + TSDB_NCHAR_SIZE);
    if (NULL == newColData) {
      TAOS_RETURN(terrno);
    }
    int len = taosUcs4ToMbs((TdUcs4*)varDataVal(inputData), charLen, newColData, charsetCxt);
    if (len < 0) {
      taosMemoryFree(newColData);
      TAOS_RETURN(TSDB_CODE_FAILED);
    }
    newColData[len] = 0;
    int32_t ret = taosParseTime(newColData, timeVal, len, (int32_t)timePrec, tz);
    if (ret != TSDB_CODE_SUCCESS) {
      taosMemoryFree(newColData);
      TAOS_RETURN(ret);
    }
    taosMemoryFree(newColData);
  } else {
    TAOS_RETURN(TSDB_CODE_FAILED);
  }
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

int32_t getDuration(int64_t val, char unit, int64_t* result, int32_t timePrecision) {
  switch (unit) {
    case 's':
      if (val > INT64_MAX / MILLISECOND_PER_SECOND) {
        TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
      }
      (*result) = convertTimePrecision(val * MILLISECOND_PER_SECOND, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'm':
      if (val > INT64_MAX / MILLISECOND_PER_MINUTE) {
        TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
      }
      (*result) = convertTimePrecision(val * MILLISECOND_PER_MINUTE, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'h':
      if (val > INT64_MAX / MILLISECOND_PER_MINUTE) {
        TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
      }
      (*result) = convertTimePrecision(val * MILLISECOND_PER_HOUR, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'd':
      if (val > INT64_MAX / MILLISECOND_PER_DAY) {
        TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
      }
      (*result) = convertTimePrecision(val * MILLISECOND_PER_DAY, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'w':
      if (val > INT64_MAX / MILLISECOND_PER_WEEK) {
        TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
      }
      (*result) = convertTimePrecision(val * MILLISECOND_PER_WEEK, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'a':
      (*result) = convertTimePrecision(val, TSDB_TIME_PRECISION_MILLI, timePrecision);
      break;
    case 'u':
      (*result) = convertTimePrecision(val, TSDB_TIME_PRECISION_MICRO, timePrecision);
      break;
    case 'b':
      (*result) = convertTimePrecision(val, TSDB_TIME_PRECISION_NANO, timePrecision);
      break;
    default: {
      TAOS_RETURN(TSDB_CODE_OUT_OF_RANGE);
    }
  }
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

/*
 * n - months
 * y - Years
 * is not allowed, since the duration of month or year are both variable.
 *
 * b - nanoseconds;
 * u - microseconds;
 * a - Millionseconds
 * s - Seconds
 * m - Minutes
 * h - Hours
 * d - Days (24 hours)
 * w - Weeks (7 days)
 */
int32_t parseAbsoluteDuration(const char* token, int32_t tokenlen, int64_t* duration, char* unit,
                              int32_t timePrecision) {
  SET_ERRNO(0);
  char* endPtr = NULL;

  /* get the basic numeric value */
  int64_t timestamp = taosStr2Int64(token, &endPtr, 10);
  if ((timestamp == 0 && token[0] != '0') || ERRNO != 0) {
    TAOS_RETURN(TAOS_SYSTEM_ERROR(ERRNO));
  }

  /* natual month/year are not allowed in absolute duration */
  *unit = token[tokenlen - 1];
  if (*unit == 'n' || *unit == 'y') {
    TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  return getDuration(timestamp, *unit, duration, timePrecision);
}

int32_t parseNatualDuration(const char* token, int32_t tokenLen, int64_t* duration, char* unit, int32_t timePrecision,
                            bool negativeAllow) {
  SET_ERRNO(0);

  /* get the basic numeric value */
  *duration = taosStr2Int64(token, NULL, 10);
  if ((*duration < 0 && !negativeAllow) || ERRNO != 0) {
    TAOS_RETURN(TAOS_SYSTEM_ERROR(ERRNO));
  }

  *unit = token[tokenLen - 1];
  if (*unit == 'n' || *unit == 'y') {
    TAOS_RETURN(TSDB_CODE_SUCCESS);
  }
  if (isdigit(*unit)) {
    *unit = getPrecisionUnit(timePrecision);
  }

  return getDuration(*duration, *unit, duration, timePrecision);
}

static bool taosIsLeapYear(int32_t year) { return (year % 4 == 0 && (year % 100 != 0 || year % 400 == 0)); }

int64_t taosTimeAdd(int64_t t, int64_t duration, char unit, int32_t precision, timezone_t tz) {
  if (duration == 0) {
    return t;
  }

  if (!IS_CALENDAR_TIME_DURATION(unit)) {
    double tmp = t;
    if (tmp + duration >= (double)INT64_MAX || tmp + duration <= (double)INT64_MIN) {
      uError("time overflow, t:%" PRId64 ", duration:%" PRId64 ", unit:%c, precision:%d", t, duration, unit, precision);
      return t;
    } else {
      return t + duration;
    }
  }

  // The following code handles the y/n time duration
  int64_t numOfMonth = (unit == 'y') ? duration * 12 : duration;
  int64_t fraction = t % TSDB_TICK_PER_SECOND(precision);

  struct tm  tm;
  time_t     tt = (time_t)(t / TSDB_TICK_PER_SECOND(precision));
  if(taosLocalTime(&tt, &tm, NULL, 0, tz) == NULL) {
    uError("failed to convert time to gm time, code:%d", ERRNO);
    return t;
  }
  int32_t    mon = tm.tm_year * 12 + tm.tm_mon + (int32_t)numOfMonth;
  tm.tm_year = mon / 12;
  tm.tm_mon = mon % 12;
  int daysOfMonth[] = {31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31};
  if (taosIsLeapYear(1900 + tm.tm_year)) {
    daysOfMonth[1] = 29;
  }
  if (tm.tm_mday > daysOfMonth[tm.tm_mon]) {
    tm.tm_mday = daysOfMonth[tm.tm_mon];
  }

  tt = taosMktime(&tm, tz);
  if (tt == -1){
    uError("failed to convert gm time to time, code:%d", ERRNO);
    return t;
  }
  return (int64_t)(tt * TSDB_TICK_PER_SECOND(precision) + fraction);
}

/**
 * @brief calc how many windows after filling between skey and ekey
 * @notes for asc order
 *     skey      --->       ekey
 *      ^                    ^
 * _____!_____.........._____|_____..
 *      |__1__)
 *            |__2__)...-->|_ret+1_)
 *      skey + ret * interval <= ekey
 *      skey + ret * interval + interval > ekey
 * ======> (ekey - skey - interval) / interval < ret <= (ekey - skey) / interval
 * For keys from blocks which do not need filling, skey + ret * interval == ekey.
 * For keys need filling, skey + ret * interval <= ekey.
 * Total num of windows is ret + 1(the last window)
 *
 *        for desc order
 *     skey       <---      ekey
 *      ^                    ^
 * _____|____..........______!____...
 *                           |_first_)
 *                     |__1__)
 *  |_ret_)<--...|__2__)
 *      skey >= ekey - ret * interval
 *      skey < ekey - ret * interval + interval
 *=======> (ekey - skey) / interval <= ret < (ekey - skey + interval) / interval
 * For keys from blocks which do not need filling, skey == ekey - ret * interval.
 * For keys need filling, skey >= ekey - ret * interval.
 * Total num of windows is ret + 1(the first window)
 */
int32_t taosTimeCountIntervalForFill(int64_t skey, int64_t ekey, int64_t interval, char unit, int32_t precision,
                                     int32_t order) {
  if (ekey < skey) {
    int64_t tmp = ekey;
    ekey = skey;
    skey = tmp;
  }
  int32_t ret = 0;

  if (unit != 'n' && unit != 'y') {
    ret = (int32_t)((ekey - skey) / interval);
    if (order == TSDB_ORDER_DESC && ret * interval < (ekey - skey)) ret += 1;
  } else {
    skey /= (int64_t)(TSDB_TICK_PER_SECOND(precision));
    ekey /= (int64_t)(TSDB_TICK_PER_SECOND(precision));

    struct tm  tm;
    time_t     t = (time_t)skey;
    if (taosLocalTime(&t, &tm, NULL, 0, NULL) == NULL) {
      uError("%s failed to convert time to local time, code:%d", __FUNCTION__, ERRNO);
      return ret;
    }
    int32_t    smon = tm.tm_year * 12 + tm.tm_mon;

    t = (time_t)ekey;
    if (taosLocalTime(&t, &tm, NULL, 0, NULL) == NULL) {
      uError("%s failed to convert time to local time, code:%d", __FUNCTION__, ERRNO);
      return ret;
    }
    int32_t emon = tm.tm_year * 12 + tm.tm_mon;

    if (unit == 'y') {
      interval *= 12;
    }
    ret = (emon - smon) / (int32_t)interval;
    if (order == TSDB_ORDER_DESC && ret * interval < (smon - emon)) ret += 1;
  }
  return ret + 1;
}

int64_t taosTimeTruncate(int64_t ts, const SInterval* pInterval) {
  if (ts <= INT64_MIN || ts >= INT64_MAX) {
    return ts;
  }
  if (pInterval->sliding == 0) {
    return ts;
  }

  int64_t start = ts;
  int32_t precision = pInterval->precision;

  if (IS_CALENDAR_TIME_DURATION(pInterval->slidingUnit)) {
    start /= (int64_t)(TSDB_TICK_PER_SECOND(precision));
    struct tm  tm;
    time_t     tt = (time_t)start;
    if (taosLocalTime(&tt, &tm, NULL, 0, pInterval->timezone) == NULL){
      uError("%s failed to convert time to local time, code:%d", __FUNCTION__, ERRNO);
      return ts;
    }
    tm.tm_sec = 0;
    tm.tm_min = 0;
    tm.tm_hour = 0;
    tm.tm_mday = 1;

    if (pInterval->slidingUnit == 'y') {
      tm.tm_mon = 0;
      tm.tm_year = (int32_t)(tm.tm_year / pInterval->sliding * pInterval->sliding);
    } else {
      int32_t mon = tm.tm_year * 12 + tm.tm_mon;
      mon = (int32_t)(mon / pInterval->sliding * pInterval->sliding);
      tm.tm_year = mon / 12;
      tm.tm_mon = mon % 12;
    }

    tt = taosMktime(&tm, pInterval->timezone);
    if (tt == -1){
      uError("%s failed to convert local time to time, code:%d", __FUNCTION__, ERRNO);
      return ts;
    }
    start = (int64_t)(tt * TSDB_TICK_PER_SECOND(precision));
  } else {
    if (IS_CALENDAR_TIME_DURATION(pInterval->intervalUnit)) {
      int64_t news = (ts / pInterval->sliding) * pInterval->sliding;
      if (pInterval->slidingUnit == 'd' || pInterval->slidingUnit == 'w') {
#if defined(WINDOWS) && _MSC_VER >= 1900
        int64_t timezone = _timezone;
#endif
        news += (int64_t)(timezone * TSDB_TICK_PER_SECOND(precision));
      }

      start = news;
      if (news <= ts) {
        int64_t prev = news;
        int64_t newe = taosTimeAdd(news, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;

        if (newe < ts) {  // move towards the greater endpoint
          while (newe < ts && news < ts) {
            news += pInterval->sliding;
            newe = taosTimeAdd(news, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;
          }

          prev = news;
        } else {
          while (newe >= ts) {
            prev = news;
            news -= pInterval->sliding;
            newe = taosTimeAdd(news, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;
          }
        }

        start = prev;
      }
    } else {
      int64_t delta = ts - pInterval->interval;
      int32_t factor = (delta >= 0) ? 1 : -1;

      start = (delta / pInterval->sliding + factor) * pInterval->sliding;

      if (pInterval->intervalUnit == 'd' || pInterval->intervalUnit == 'w') {
        /*
         * here we revised the start time of day according to the local time zone,
         * but in case of DST, the start time of one day need to be dynamically decided.
         */
        // todo refactor to extract function that is available for Linux/Windows/Mac platform
#if defined(WINDOWS) && _MSC_VER >= 1900
        // see
        // https://docs.microsoft.com/en-us/cpp/c-runtime-library/daylight-dstbias-timezone-and-tzname?view=vs-2019
        int64_t timezone = _timezone;
#endif

        start += (int64_t)(timezone * TSDB_TICK_PER_SECOND(precision));
      }

      int64_t end = 0;

      // not enough time range
      if (start < 0 || INT64_MAX - start > pInterval->interval - 1) {
        end = taosTimeAdd(start, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;
        while (end < ts) {  // move forward to the correct time window
          start += pInterval->sliding;

          if (start < 0 || INT64_MAX - start > pInterval->interval - 1) {
            end = start + pInterval->interval - 1;
          } else {
            end = INT64_MAX;
            break;
          }
        }
      } else {
        end = INT64_MAX;
      }
    }
  }

  if (pInterval->offset > 0) {
    // try to move current window to the left-hande-side, due to the offset effect.
    int64_t newe = taosTimeAdd(start, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;
    int64_t slidingStart = start;
    while (newe >= ts) {
      start = slidingStart;
      slidingStart = taosTimeAdd(slidingStart, -pInterval->sliding, pInterval->slidingUnit, precision, pInterval->timezone);
      int64_t news = taosTimeAdd(slidingStart, pInterval->offset, pInterval->offsetUnit, precision, pInterval->timezone);
      newe = taosTimeAdd(news, pInterval->interval, pInterval->intervalUnit, precision, pInterval->timezone) - 1;
    }
    start = taosTimeAdd(start, pInterval->offset, pInterval->offsetUnit, precision, pInterval->timezone);
  }

  return start;
}

// used together with taosTimeTruncate. when offset is great than zero, slide-start/slide-end is the anchor point
int64_t taosTimeGetIntervalEnd(int64_t intervalStart, const SInterval* pInterval) {
  return taosTimeAdd(intervalStart, pInterval->interval, pInterval->intervalUnit, pInterval->precision, pInterval->timezone) - 1;
}

void calcIntervalAutoOffset(SInterval* interval) {
  if (!interval || interval->offset != AUTO_DURATION_VALUE) {
    return;
  }

  interval->offset = 0;

  if (interval->timeRange.skey == INT64_MIN) {
    return;
  }

  TSKEY skey = interval->timeRange.skey;
  TSKEY start = taosTimeTruncate(skey, interval);
  TSKEY news = start;
  while (news <= skey) {
    start = news;
    news = taosTimeAdd(start, interval->sliding, interval->slidingUnit, interval->precision, interval->timezone);
    if (news < start) {
      // overflow happens
      uError("%s failed and skip, skey [%" PRId64 "], inter[%" PRId64 "(%c)], slid[%" PRId64 "(%c)], precision[%d]",
             __func__, skey, interval->interval, interval->intervalUnit, interval->sliding, interval->slidingUnit,
             interval->precision);
      return;
    }
  }
  interval->offset = skey - start;
}

// internal function, when program is paused in debugger,
// one can call this function from debugger to print a
// timestamp as human readable string, for example (gdb):
//     p fmtts(1593769722)
// outputs:
//     2020-07-03 17:48:42
// and the parameter can also be a variable.
const char* fmtts(int64_t ts) {
  static char buf[TD_TIME_STR_LEN] = {0};
  size_t      pos = 0;
  struct tm   tm;

  if (ts > -62135625943 && ts < 32503651200) {
    time_t t = (time_t)ts;
    if (taosLocalTime(&t, &tm, buf, sizeof(buf), NULL) == NULL) {
      return buf;
    }
    pos += taosStrfTime(buf + pos, sizeof(buf), "s=%Y-%m-%d %H:%M:%S", &tm);
  }

  if (ts > -62135625943000 && ts < 32503651200000) {
    time_t t = (time_t)(ts / 1000);
    if (taosLocalTime(&t, &tm, buf, sizeof(buf), NULL) == NULL) {
      return buf;
    }
    if (pos > 0) {
      buf[pos++] = ' ';
      buf[pos++] = '|';
      buf[pos++] = ' ';
    }
    pos += taosStrfTime(buf + pos, sizeof(buf), "ms=%Y-%m-%d %H:%M:%S", &tm);
    pos += sprintf(buf + pos, ".%03d", (int32_t)(ts % 1000));
  }

  {
    time_t t = (time_t)(ts / 1000000);
    if (taosLocalTime(&t, &tm, buf, sizeof(buf), NULL) == NULL) {
      return buf;
    }
    if (pos > 0) {
      buf[pos++] = ' ';
      buf[pos++] = '|';
      buf[pos++] = ' ';
    }
    pos += taosStrfTime(buf + pos, sizeof(buf), "us=%Y-%m-%d %H:%M:%S", &tm);
    pos += sprintf(buf + pos, ".%06d", (int32_t)(ts % 1000000));
  }

  return buf;
}

int32_t taosFormatUtcTime(char* buf, int32_t bufLen, int64_t t, int32_t precision) {
  char      ts[40] = {0};
  struct tm ptm;

  int32_t fractionLen;
  char*   format = NULL;
  time_t  quot = 0;
  long    mod = 0;

  switch (precision) {
    case TSDB_TIME_PRECISION_MILLI: {
      quot = t / 1000;
      fractionLen = 5;
      format = ".%03" PRId64;
      mod = t % 1000;
      break;
    }

    case TSDB_TIME_PRECISION_MICRO: {
      quot = t / 1000000;
      fractionLen = 8;
      format = ".%06" PRId64;
      mod = t % 1000000;
      break;
    }

    case TSDB_TIME_PRECISION_NANO: {
      quot = t / 1000000000;
      fractionLen = 11;
      format = ".%09" PRId64;
      mod = t % 1000000000;
      break;
    }

    default:
      fractionLen = 0;
      TAOS_RETURN(TSDB_CODE_INVALID_PARA);
  }

  if (NULL == taosLocalTime(&quot, &ptm, buf, bufLen, NULL)) {
    TAOS_RETURN(TAOS_SYSTEM_ERROR(ERRNO));
  }
  int32_t length = (int32_t)taosStrfTime(ts, 40, "%Y-%m-%dT%H:%M:%S", &ptm);
  length += tsnprintf(ts + length, fractionLen, format, mod);
  length += (int32_t)taosStrfTime(ts + length, 40 - length, "%z", &ptm);

  tstrncpy(buf, ts, bufLen);
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

char* formatTimestampLocal(char* buf, int64_t val, int precision) {
  time_t tt;
  if (precision == TSDB_TIME_PRECISION_MICRO) {
    tt = (time_t)(val / 1000000);
  } else if (precision == TSDB_TIME_PRECISION_NANO) {
    tt = (time_t)(val / 1000000000);
  } else {
    tt = (time_t)(val / 1000);
  }

  struct tm tm;
  if (taosLocalTime(&tt, &tm, NULL, 0, NULL) == NULL) {
    return NULL;
  }
  size_t pos = taosStrfTime(buf, 32, "%Y-%m-%d %H:%M:%S", &tm);

  if (precision == TSDB_TIME_PRECISION_MICRO) {
    sprintf(buf + pos, ".%06d", (int)(val % 1000000));
  } else if (precision == TSDB_TIME_PRECISION_NANO) {
    sprintf(buf + pos, ".%09d", (int)(val % 1000000000));
  } else {
    sprintf(buf + pos, ".%03d", (int)(val % 1000));
  }

  return buf;
}

int32_t taosTs2Tm(int64_t ts, int32_t precision, struct STm* tm, timezone_t tz) {
  tm->fsec = ts % TICK_PER_SECOND[precision] * (TICK_PER_SECOND[TSDB_TIME_PRECISION_NANO] / TICK_PER_SECOND[precision]);
  time_t t = ts / TICK_PER_SECOND[precision];
  if (NULL == taosLocalTime(&t, &tm->tm, NULL, 0, tz)) {
    TAOS_RETURN(TAOS_SYSTEM_ERROR(ERRNO));
  }
  return TSDB_CODE_SUCCESS;
}

int32_t taosTm2Ts(struct STm* tm, int64_t* ts, int32_t precision, timezone_t tz) {
  *ts = taosMktime(&tm->tm, tz);
  *ts *= TICK_PER_SECOND[precision];
  *ts += tm->fsec / (TICK_PER_SECOND[TSDB_TIME_PRECISION_NANO] / TICK_PER_SECOND[precision]);
  return TSDB_CODE_SUCCESS;
}

typedef struct {
  const char* name;
  int         len;
  int         id;
  bool        isDigit;
} TSFormatKeyWord;

typedef enum {
  // TSFKW_AD,   // BC AD
  // TSFKW_A_D,  // A.D. B.C.
  TSFKW_AM,   // AM, PM
  TSFKW_A_M,  // A.M., P.M.
  // TSFKW_BC,   // BC AD
  // TSFKW_B_C,  // B.C. A.D.
  TSFKW_DAY,  // MONDAY, TUESDAY ...
  TSFKW_DDD,  // Day of year 001-366
  TSFKW_DD,   // Day of month 01-31
  TSFKW_Day,  // Sunday, Monday
  TSFKW_DY,   // MON, TUE
  TSFKW_Dy,   // Mon, Tue
  TSFKW_D,    // 1-7 -> Sunday(1) -> Saturday(7)
  TSFKW_HH24,
  TSFKW_HH12,
  TSFKW_HH,
  TSFKW_MI,  // minute
  TSFKW_MM,
  TSFKW_MONTH,  // JANUARY, FEBRUARY
  TSFKW_MON,
  TSFKW_Month,
  TSFKW_Mon,
  TSFKW_MS,
  TSFKW_NS,
  // TSFKW_OF,
  TSFKW_PM,
  TSFKW_P_M,
  TSFKW_SS,
  TSFKW_TZH,
  // TSFKW_TZM,
  // TSFKW_TZ,
  TSFKW_US,
  TSFKW_YYYY,
  TSFKW_YYY,
  TSFKW_YY,
  TSFKW_Y,
  // TSFKW_a_d,
  // TSFKW_ad,
  TSFKW_am,
  TSFKW_a_m,
  // TSFKW_b_c,
  // TSFKW_bc,
  TSFKW_day,
  TSFKW_ddd,
  TSFKW_dd,
  TSFKW_dy,  // mon, tue
  TSFKW_d,
  TSFKW_hh24,
  TSFKW_hh12,
  TSFKW_hh,
  TSFKW_mi,
  TSFKW_mm,
  TSFKW_month,
  TSFKW_mon,
  TSFKW_ms,
  TSFKW_ns,
  TSFKW_pm,
  TSFKW_p_m,
  TSFKW_ss,
  TSFKW_tzh,
  // TSFKW_tzm,
  // TSFKW_tz,
  TSFKW_us,
  TSFKW_yyyy,
  TSFKW_yyy,
  TSFKW_yy,
  TSFKW_y,
  TSFKW_last_
} TSFormatKeywordId;

// clang-format off
static const TSFormatKeyWord formatKeyWords[] = {
  //{"AD", 2, TSFKW_AD, false},
  //{"A.D.", 4, TSFKW_A_D},
  {"AM", 2, TSFKW_AM, false},
  {"A.M.", 4, TSFKW_A_M, false},
  //{"BC", 2, TSFKW_BC, false},
  //{"B.C.", 4, TSFKW_B_C, false},
  {"DAY", 3, TSFKW_DAY, false},
  {"DDD", 3, TSFKW_DDD, true},
  {"DD", 2, TSFKW_DD, true},
  {"Day", 3, TSFKW_Day, false},
  {"DY", 2, TSFKW_DY, false},
  {"Dy", 2, TSFKW_Dy, false},
  {"D", 1, TSFKW_D, true},
  {"HH24", 4, TSFKW_HH24, true},
  {"HH12", 4, TSFKW_HH12, true},
  {"HH", 2, TSFKW_HH, true},
  {"MI", 2, TSFKW_MI, true},
  {"MM", 2, TSFKW_MM, true},
  {"MONTH", 5, TSFKW_MONTH, false},
  {"MON", 3, TSFKW_MON, false},
  {"Month", 5, TSFKW_Month, false},
  {"Mon", 3, TSFKW_Mon, false},
  {"MS", 2, TSFKW_MS, true},
  {"NS", 2, TSFKW_NS, true},
  //{"OF", 2, TSFKW_OF, false},
  {"PM", 2, TSFKW_PM, false},
  {"P.M.", 4, TSFKW_P_M, false},
  {"SS", 2, TSFKW_SS, true},
  {"TZH", 3, TSFKW_TZH, false},
  //{"TZM", 3, TSFKW_TZM},
  //{"TZ", 2, TSFKW_TZ},
  {"US", 2, TSFKW_US, true},
  {"YYYY", 4, TSFKW_YYYY, true},
  {"YYY", 3, TSFKW_YYY, true},
  {"YY", 2, TSFKW_YY, true},
  {"Y", 1, TSFKW_Y, true},
  //{"a.d.", 4, TSFKW_a_d, false},
  //{"ad", 2, TSFKW_ad, false},
  {"am", 2, TSFKW_am, false},
  {"a.m.", 4, TSFKW_a_m, false},
  //{"b.c.", 4, TSFKW_b_c, false},
  //{"bc", 2, TSFKW_bc, false},
  {"day", 3, TSFKW_day, false},
  {"ddd", 3, TSFKW_DDD, true},
  {"dd", 2, TSFKW_DD, true},
  {"dy", 2, TSFKW_dy, false},
  {"d", 1, TSFKW_D, true},
  {"hh24", 4, TSFKW_HH24, true},
  {"hh12", 4, TSFKW_HH12, true},
  {"hh", 2, TSFKW_HH, true},
  {"mi", 2, TSFKW_MI, true},
  {"mm", 2, TSFKW_MM, true},
  {"month", 5, TSFKW_month, false},
  {"mon", 3, TSFKW_mon, false},
  {"ms", 2, TSFKW_MS, true},
  {"ns", 2, TSFKW_NS, true},
  //{"of", 2, TSFKW_OF, false},
  {"pm", 2, TSFKW_pm, false},
  {"p.m.", 4, TSFKW_p_m, false},
  {"ss", 2, TSFKW_SS, true},
  {"tzh", 3, TSFKW_TZH, false},
  //{"tzm", 3, TSFKW_TZM},
  //{"tz", 2, TSFKW_tz},
  {"us", 2, TSFKW_US, true},
  {"yyyy", 4, TSFKW_YYYY, true},
  {"yyy", 3, TSFKW_YYY, true},
  {"yy", 2, TSFKW_YY, true},
  {"y", 1, TSFKW_Y, true},
  {NULL, 0, 0}
};
// clang-format on

#define TS_FROMAT_KEYWORD_INDEX_SIZE ('z' - 'A' + 1)
static const int TSFormatKeywordIndex[TS_FROMAT_KEYWORD_INDEX_SIZE] = {
    /*A*/ TSFKW_AM,     -1, -1,
    /*D*/ TSFKW_DAY,    -1, -1, -1,
    /*H*/ TSFKW_HH24,   -1, -1, -1, -1,
    /*M*/ TSFKW_MI,
    /*N*/ TSFKW_NS,     -1,
    /*P*/ TSFKW_PM,     -1, -1,
    /*S*/ TSFKW_SS,
    /*T*/ TSFKW_TZH,
    /*U*/ TSFKW_US,     -1, -1, -1,
    /*Y*/ TSFKW_YYYY,   -1,
    /*[ \ ] ^ _ `*/ -1, -1, -1, -1, -1, -1,
    /*a*/ TSFKW_am,     -1, -1,
    /*d*/ TSFKW_day,    -1, -1, -1,
    /*h*/ TSFKW_hh24,   -1, -1, -1, -1,
    /*m*/ TSFKW_mi,
    /*n*/ TSFKW_ns,     -1,
    /*p*/ TSFKW_pm,     -1, -1,
    /*s*/ TSFKW_ss,
    /*t*/ TSFKW_tzh,
    /*u*/ TSFKW_us,     -1, -1, -1,
    /*y*/ TSFKW_yyyy,   -1};

typedef struct {
  uint8_t                type;
  const char*            c;
  int32_t                len;
  const TSFormatKeyWord* key;
} TSFormatNode;

static const char* const weekDays[] = {"Sunday",   "Monday", "Tuesday",  "Wednesday",
                                       "Thursday", "Friday", "Saturday", "NULL"};
static const char* const shortWeekDays[] = {"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "NULL"};
static const char* const fullMonths[] = {"January", "February",  "March",   "April",    "May",      "June", "July",
                                         "August",  "September", "October", "November", "December", NULL};
static const char* const months[] = {"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul",
                                     "Aug", "Sep", "Oct", "Nov", "Dec", NULL};
#define A_M_STR "A.M."
#define a_m_str "a.m."
#define AM_STR  "AM"
#define am_str  "am"
#define P_M_STR "P.M."
#define p_m_str "p.m."
#define PM_STR  "PM"
#define pm_str  "pm"
static const char* const apms[] = {AM_STR, PM_STR, am_str, pm_str, NULL};
static const char* const long_apms[] = {A_M_STR, P_M_STR, a_m_str, p_m_str, NULL};

#define TS_FORMAT_NODE_TYPE_KEYWORD   1
#define TS_FORMAT_NODE_TYPE_SEPARATOR 2
#define TS_FORMAT_NODE_TYPE_CHAR      3

static const TSFormatKeyWord* keywordSearch(const char* str) {
  if (*str < 'A' || *str > 'z' || (*str > 'Z' && *str < 'a')) return NULL;
  int32_t idx = TSFormatKeywordIndex[str[0] - 'A'];
  if (idx < 0) return NULL;
  const TSFormatKeyWord* key = &formatKeyWords[idx++];
  while (key->name && str[0] == key->name[0]) {
    if (0 == strncmp(key->name, str, key->len)) {
      return key;
    }
    key = &formatKeyWords[idx++];
  }
  return NULL;
}

static bool isSeperatorChar(char c) {
  return (c > 0x20 && c < 0x7F && !(c >= 'A' && c <= 'Z') && !(c >= 'a' && c <= 'z') && !(c >= '0' && c <= '9'));
}

static int32_t parseTsFormat(const char* formatStr, SArray* formats) {
  TSFormatNode* lastOtherFormat = NULL;
  while (*formatStr) {
    const TSFormatKeyWord* key = keywordSearch(formatStr);
    if (key) {
      TSFormatNode format = {.key = key, .type = TS_FORMAT_NODE_TYPE_KEYWORD};
      if (NULL == taosArrayPush(formats, &format)) TAOS_RETURN(terrno);
      formatStr += key->len;
      lastOtherFormat = NULL;
    } else {
      if (*formatStr == '"') {
        lastOtherFormat = NULL;
        // for double quoted string
        formatStr++;
        TSFormatNode* last = NULL;
        while (*formatStr) {
          if (*formatStr == '"') {
            formatStr++;
            break;
          }
          if (*formatStr == '\\' && *(formatStr + 1)) {
            formatStr++;
            last = NULL;  // stop expanding last format, create new format
          }
          if (last) {
            // expand
            last->len++;
            formatStr++;
          } else {
            // create new
            TSFormatNode format = {.type = TS_FORMAT_NODE_TYPE_CHAR, .key = NULL};
            format.c = formatStr;
            format.len = 1;
            if (NULL == taosArrayPush(formats, &format)) TAOS_RETURN(terrno);
            formatStr++;
            last = taosArrayGetLast(formats);
          }
        }
      } else {
        // for other strings
        if (*formatStr == '\\' && *(formatStr + 1)) {
          formatStr++;
          lastOtherFormat = NULL;  // stop expanding
        } else {
          if (lastOtherFormat && !isSeperatorChar(*formatStr)) {
            // expanding
          } else {
            // create new
            lastOtherFormat = NULL;
          }
        }
        if (lastOtherFormat) {
          lastOtherFormat->len++;
          formatStr++;
        } else {
          TSFormatNode format = {
              .type = isSeperatorChar(*formatStr) ? TS_FORMAT_NODE_TYPE_SEPARATOR : TS_FORMAT_NODE_TYPE_CHAR,
              .key = NULL};
          format.c = formatStr;
          format.len = 1;
          if (NULL == taosArrayPush(formats, &format)) TAOS_RETURN(terrno);
          formatStr++;
          if (format.type == TS_FORMAT_NODE_TYPE_CHAR) lastOtherFormat = taosArrayGetLast(formats);
        }
      }
    }
  }
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

static int32_t tm2char(const SArray* formats, const struct STm* tm, char* s, int32_t outLen) {
  int32_t     size = taosArrayGetSize(formats);
  const char* start = s;
  for (int32_t i = 0; i < size; ++i) {
    TSFormatNode* format = taosArrayGet(formats, i);
    if (format->type != TS_FORMAT_NODE_TYPE_KEYWORD) {
      if (s - start + format->len + 1 > outLen) break;
      (void)strncpy(s, format->c, format->len);
      s += format->len;
      continue;
    }
    if (s - start + 16 > outLen) break;

    switch (format->key->id) {
      case TSFKW_AM:
      case TSFKW_PM:
        (void)sprintf(s, tm->tm.tm_hour % 24 >= 12 ? "PM" : "AM");
        s += 2;
        break;
      case TSFKW_A_M:
      case TSFKW_P_M:
        (void)sprintf(s, tm->tm.tm_hour % 24 >= 12 ? "P.M." : "A.M.");
        s += 4;
        break;
      case TSFKW_am:
      case TSFKW_pm:
        (void)sprintf(s, tm->tm.tm_hour % 24 >= 12 ? "pm" : "am");
        s += 2;
        break;
      case TSFKW_a_m:
      case TSFKW_p_m:
        (void)sprintf(s, tm->tm.tm_hour % 24 >= 12 ? "p.m." : "a.m.");
        s += 4;
        break;
      case TSFKW_DDD:
        (void)sprintf(s, "%03d", tm->tm.tm_yday + 1);
        s += strlen(s);
        break;
      case TSFKW_DD:
        (void)sprintf(s, "%02d", tm->tm.tm_mday);
        s += 2;
        break;
      case TSFKW_D:
        (void)sprintf(s, "%d", tm->tm.tm_wday + 1);
        s += 1;
        break;
      case TSFKW_DAY: {
        // MONDAY, TUESDAY...
        const char* wd = weekDays[tm->tm.tm_wday];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(wd); ++i) buf[i] = toupper(wd[i]);
        (void)sprintf(s, "%-9s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_Day:
        // Monday, TuesDay...
        (void)sprintf(s, "%-9s", weekDays[tm->tm.tm_wday]);
        s += strlen(s);
        break;
      case TSFKW_day: {
        const char* wd = weekDays[tm->tm.tm_wday];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(wd); ++i) buf[i] = tolower(wd[i]);
        (void)sprintf(s, "%-9s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_DY: {
        // MON, TUE
        const char* wd = shortWeekDays[tm->tm.tm_wday];
        char        buf[8] = {0};
        for (int32_t i = 0; i < strlen(wd); ++i) buf[i] = toupper(wd[i]);
        (void)sprintf(s, "%3s", buf);
        s += 3;
        break;
      }
      case TSFKW_Dy:
        // Mon, Tue
        (void)sprintf(s, "%3s", shortWeekDays[tm->tm.tm_wday]);
        s += 3;
        break;
      case TSFKW_dy: {
        // mon, tue
        const char* wd = shortWeekDays[tm->tm.tm_wday];
        char        buf[8] = {0};
        for (int32_t i = 0; i < strlen(wd); ++i) buf[i] = tolower(wd[i]);
        (void)sprintf(s, "%3s", buf);
        s += 3;
        break;
      }
      case TSFKW_HH24:
        (void)sprintf(s, "%02d", tm->tm.tm_hour);
        s += 2;
        break;
      case TSFKW_HH:
      case TSFKW_HH12:
        // 0 or 12 o'clock in 24H coresponds to 12 o'clock (AM/PM) in 12H
        (void)sprintf(s, "%02d", tm->tm.tm_hour % 12 == 0 ? 12 : tm->tm.tm_hour % 12);
        s += 2;
        break;
      case TSFKW_MI:
        (void)sprintf(s, "%02d", tm->tm.tm_min);
        s += 2;
        break;
      case TSFKW_MM:
        (void)sprintf(s, "%02d", tm->tm.tm_mon + 1);
        s += 2;
        break;
      case TSFKW_MONTH: {
        const char* mon = fullMonths[tm->tm.tm_mon];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(mon); ++i) buf[i] = toupper(mon[i]);
        (void)sprintf(s, "%-9s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_MON: {
        const char* mon = months[tm->tm.tm_mon];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(mon); ++i) buf[i] = toupper(mon[i]);
        (void)sprintf(s, "%s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_Month:
        (void)sprintf(s, "%-9s", fullMonths[tm->tm.tm_mon]);
        s += strlen(s);
        break;
      case TSFKW_month: {
        const char* mon = fullMonths[tm->tm.tm_mon];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(mon); ++i) buf[i] = tolower(mon[i]);
        (void)sprintf(s, "%-9s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_Mon:
        (void)sprintf(s, "%s", months[tm->tm.tm_mon]);
        s += strlen(s);
        break;
      case TSFKW_mon: {
        const char* mon = months[tm->tm.tm_mon];
        char        buf[10] = {0};
        for (int32_t i = 0; i < strlen(mon); ++i) buf[i] = tolower(mon[i]);
        (void)sprintf(s, "%s", buf);
        s += strlen(s);
        break;
      }
      case TSFKW_SS:
        (void)sprintf(s, "%02d", tm->tm.tm_sec);
        s += 2;
        break;
      case TSFKW_MS:
        (void)sprintf(s, "%03" PRId64, tm->fsec / 1000000L);
        s += 3;
        break;
      case TSFKW_US:
        (void)sprintf(s, "%06" PRId64, tm->fsec / 1000L);
        s += 6;
        break;
      case TSFKW_NS:
        (void)sprintf(s, "%09" PRId64, tm->fsec);
        s += 9;
        break;
      case TSFKW_TZH:{
#ifdef WINDOWS
        int32_t gmtoff = -_timezone;
#elif defined(TD_ASTRA)
        int32_t gmtoff = -timezone;
#else
        int32_t gmtoff = tm->tm.tm_gmtoff;
#endif
        (void)sprintf(s, "%c%02d", (gmtoff >= 0) ? '+' : '-',
                      abs(gmtoff) / 3600);
        s += strlen(s);
        break;
      }
      case TSFKW_YYYY:
        (void)sprintf(s, "%04d", tm->tm.tm_year + 1900);
        s += strlen(s);
        break;
      case TSFKW_YYY:
        (void)sprintf(s, "%03d", (tm->tm.tm_year + 1900) % 1000);
        s += strlen(s);
        break;
      case TSFKW_YY:
        (void)sprintf(s, "%02d", (tm->tm.tm_year + 1900) % 100);
        s += strlen(s);
        break;
      case TSFKW_Y:
        (void)sprintf(s, "%01d", (tm->tm.tm_year + 1900) % 10);
        s += strlen(s);
        break;
      default:
        break;
    }
  }
  return TSDB_CODE_SUCCESS;
}

/// @brief find s in arr case insensitively
/// @retval the index in arr if found, -1 if not found
static int32_t strArrayCaseSearch(const char* const* arr, const char* s) {
  if (!*s) return -1;
  const char* const* fmt = arr;
  for (; *fmt; ++fmt) {
    const char *l, *r;
    for (l = fmt[0], r = s;; l++, r++) {
      if (*l == '\0') return fmt - arr;
      if (*r == '\0' || tolower(*l) != tolower(*r)) break;
    }
  }
  return -1;
}

static const char* tsFormatStr2Int32(int32_t* dest, const char* str, int32_t len, bool needMoreDigit) {
  char*       last;
  int64_t     res;
  const char* s = str;
  if ('\0' == str[0]) return NULL;
  if (len <= 0) {
    res = taosStr2Int64(s, &last, 10);
    s = last;
  } else {
    char buf[16] = {0};
    (void)strncpy(buf, s, len);
    int32_t copiedLen = strlen(buf);
    if (copiedLen < len) {
      if (!needMoreDigit) {
        // digits not enough, that's ok, cause we do not need more digits
        // '2023-1' 'YYYY-MM'
        // '202a' 'YYYY' -> 202
        res = taosStr2Int64(s, &last, 10);
        s += copiedLen;
      } else {
        // bytes not enough, and there are other digit formats to match
        // '2023-1' 'YYYY-MMDD'
        return NULL;
      }
    } else {
      if (needMoreDigit) {
        res = taosStr2Int64(buf, &last, 10);
        // bytes enough, but digits not enough, like '202a12' 'YYYYMM', YYYY needs four digits
        if (last - buf < len) return NULL;
        s += last - buf;
      } else {
        res = taosStr2Int64(s, &last, 10);
        s = last;
      }
    }
  }
  if (s == str) {
    // no integers found
    return NULL;
  }
  if (ERRNO == ERANGE || res > INT32_MAX || res < INT32_MIN) {
    // out of range
    return NULL;
  }
  *dest = res;
  return s;
}

static int32_t adjustYearTo2020(int32_t year) {
  if (year < 70) return year + 2000;    // 2000 - 2069
  if (year < 100) return year + 1900;   // 1970 - 1999
  if (year < 520) return year + 2000;   // 2100 - 2519
  if (year < 1000) return year + 1000;  // 1520 - 1999
  return year;
}

static bool checkTm(const struct tm* tm) {
  if (tm->tm_mon < 0 || tm->tm_mon > 11) return false;
  if (tm->tm_wday < 0 || tm->tm_wday > 6) return false;
  if (tm->tm_yday < 0 || tm->tm_yday > 365) return false;
  if (tm->tm_mday < 0 || tm->tm_mday > 31) return false;
  if (tm->tm_hour < 0 || tm->tm_hour > 23) return false;
  if (tm->tm_min < 0 || tm->tm_min > 59) return false;
  if (tm->tm_sec < 0 || tm->tm_sec > 60) return false;
  return true;
}

static bool needMoreDigits(SArray* formats, int32_t curIdx) {
  if (curIdx == taosArrayGetSize(formats) - 1) return false;
  TSFormatNode* pNextNode = taosArrayGet(formats, curIdx + 1);
  if (pNextNode->type == TS_FORMAT_NODE_TYPE_SEPARATOR) {
    return false;
  } else if (pNextNode->type == TS_FORMAT_NODE_TYPE_KEYWORD) {
    return pNextNode->key->isDigit;
  } else {
    return isdigit(pNextNode->c[0]);
  }
}

/// @brief convert a formatted time str to timestamp
/// @param[in] s the formatted timestamp str
/// @param[in] formats array of TSFormatNode, output of parseTsFormat
/// @param[out] ts output timestamp
/// @param precision the timestamp precision to convert to, sec/milli/micro/nano
/// @param[out] sErrPos if not NULL, when err occured, points to the failed position of s, only set when ret is -1
/// @param[out] fErrIdx if not NULL, when err occured, the idx of the failed format idx, only set when ret is -1
/// @retval 0 for success
/// @retval -1 for format and s mismatch error
/// @retval -2 if datetime err, like 2023-13-32 25:61:69
/// @retval -3 if not supported
static int32_t char2ts(const char* s, SArray* formats, int64_t* ts, int32_t precision, const char** sErrPos,
                       int32_t* fErrIdx, timezone_t tz) {
  int32_t size = taosArrayGetSize(formats);
  int32_t pm = 0;      // default am
  int32_t hour12 = 0;  // default HH24
  int32_t year = 0, mon = 0, yd = 0, md = 1, wd = 0;
  int32_t hour = 0, min = 0, sec = 0, us = 0, ms = 0, ns = 0;
  int32_t tzHour = 0;
  int32_t err = 0;
  bool    withYD = false, withMD = false;

  for (int32_t i = 0; i < size && *s != '\0'; ++i) {
    while (isspace(*s) && *s != '\0') {
      s++;
    }
    if (!s) break;
    TSFormatNode* node = taosArrayGet(formats, i);
    if (node->type == TS_FORMAT_NODE_TYPE_SEPARATOR) {
      // separator matches any character
      if (isSeperatorChar(s[0])) s += node->len;
      continue;
    }
    if (node->type == TS_FORMAT_NODE_TYPE_CHAR) {
      int32_t pos = 0;
      // skip leading spaces
      while (isspace(node->c[pos]) && node->len > 0) pos++;
      while (pos < node->len && *s != '\0') {
        if (!isspace(node->c[pos++])) {
          while (isspace(*s) && *s != '\0') s++;
          if (*s != '\0') s++;  // forward together
        }
      }
      continue;
    }
    switch (node->key->id) {
      case TSFKW_A_M:
      case TSFKW_P_M:
      case TSFKW_a_m:
      case TSFKW_p_m: {
        int32_t idx = strArrayCaseSearch(long_apms, s);
        if (idx >= 0) {
          s += 4;
          pm = idx % 2;
          hour12 = 1;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_AM:
      case TSFKW_PM:
      case TSFKW_am:
      case TSFKW_pm: {
        int32_t idx = strArrayCaseSearch(apms, s);
        if (idx >= 0) {
          s += 2;
          pm = idx % 2;
          hour12 = 1;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_HH:
      case TSFKW_HH12: {
        const char* newPos = tsFormatStr2Int32(&hour, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos || hour > 12 || hour <= 0) {
          err = -1;
        } else {
          hour12 = 1;
          s = newPos;
        }
      } break;
      case TSFKW_HH24: {
        const char* newPos = tsFormatStr2Int32(&hour, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          hour12 = 0;
          s = newPos;
        }
      } break;
      case TSFKW_MI: {
        const char* newPos = tsFormatStr2Int32(&min, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
        }
      } break;
      case TSFKW_SS: {
        const char* newPos = tsFormatStr2Int32(&sec, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos)
          err = -1;
        else
          s = newPos;
      } break;
      case TSFKW_MS: {
        const char* newPos = tsFormatStr2Int32(&ms, s, 3, needMoreDigits(formats, i));
        if (NULL == newPos)
          err = -1;
        else {
          int32_t len = newPos - s;
          ms *= len == 1 ? 100 : len == 2 ? 10 : 1;
          s = newPos;
        }
      } break;
      case TSFKW_US: {
        const char* newPos = tsFormatStr2Int32(&us, s, 6, needMoreDigits(formats, i));
        if (NULL == newPos)
          err = -1;
        else {
          int32_t len = newPos - s;
          us *= len == 1 ? 100000 : len == 2 ? 10000 : len == 3 ? 1000 : len == 4 ? 100 : len == 5 ? 10 : 1;
          s = newPos;
        }
      } break;
      case TSFKW_NS: {
        const char* newPos = tsFormatStr2Int32(&ns, s, 9, needMoreDigits(formats, i));
        if (NULL == newPos)
          err = -1;
        else {
          int32_t len = newPos - s;
          ns *= len == 1   ? 100000000
                : len == 2 ? 10000000
                : len == 3 ? 1000000
                : len == 4 ? 100000
                : len == 5 ? 10000
                : len == 6 ? 1000
                : len == 7 ? 100
                : len == 8 ? 10
                           : 1;
          s = newPos;
        }
      } break;
      case TSFKW_TZH: {
        const char* newPos = tsFormatStr2Int32(&tzHour, s, -1, needMoreDigits(formats, i));
        if (NULL == newPos)
          err = -1;
        else {
          s = newPos;
        }
      } break;
      case TSFKW_MONTH:
      case TSFKW_Month:
      case TSFKW_month: {
        int32_t idx = strArrayCaseSearch(fullMonths, s);
        if (idx >= 0) {
          s += strlen(fullMonths[idx]);
          mon = idx;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_MON:
      case TSFKW_Mon:
      case TSFKW_mon: {
        int32_t idx = strArrayCaseSearch(months, s);
        if (idx >= 0) {
          s += strlen(months[idx]);
          mon = idx;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_MM: {
        const char* newPos = tsFormatStr2Int32(&mon, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
          mon -= 1;
        }
      } break;
      case TSFKW_DAY:
      case TSFKW_Day:
      case TSFKW_day: {
        int32_t idx = strArrayCaseSearch(weekDays, s);
        if (idx >= 0) {
          s += strlen(weekDays[idx]);
          wd = idx;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_DY:
      case TSFKW_Dy:
      case TSFKW_dy: {
        int32_t idx = strArrayCaseSearch(shortWeekDays, s);
        if (idx >= 0) {
          s += strlen(shortWeekDays[idx]);
          wd = idx;
        } else {
          err = -1;
        }
      } break;
      case TSFKW_DDD: {
        const char* newPos = tsFormatStr2Int32(&yd, s, 3, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
        }
        withYD = true;
      } break;
      case TSFKW_DD: {
        const char* newPos = tsFormatStr2Int32(&md, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
        }
        withMD = true;
      } break;
      case TSFKW_D: {
        const char* newPos = tsFormatStr2Int32(&wd, s, 1, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
        }
      } break;
      case TSFKW_YYYY: {
        const char* newPos = tsFormatStr2Int32(&year, s, 4, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          s = newPos;
        }
      } break;
      case TSFKW_YYY: {
        const char* newPos = tsFormatStr2Int32(&year, s, 3, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          year = adjustYearTo2020(year);
          s = newPos;
        }
      } break;
      case TSFKW_YY: {
        const char* newPos = tsFormatStr2Int32(&year, s, 2, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          year = adjustYearTo2020(year);
          s = newPos;
        }
      } break;
      case TSFKW_Y: {
        const char* newPos = tsFormatStr2Int32(&year, s, 1, needMoreDigits(formats, i));
        if (NULL == newPos) {
          err = -1;
        } else {
          year = adjustYearTo2020(year);
          s = newPos;
        }
      } break;
      default:
        break;
    }
    if (err) {
      if (sErrPos) *sErrPos = s;
      if (fErrIdx) *fErrIdx = i;
      return err;
    }
  }
  if (!withMD) {
    // yyyy-mm-DDD, currently, the c api can't convert to correct timestamp, return not supported
    if (withYD) return -3;
  }
  struct STm tm = {0};
  tm.tm.tm_year = year - 1900;
  tm.tm.tm_mon = mon;
  tm.tm.tm_yday = yd;
  tm.tm.tm_mday = md;
  tm.tm.tm_wday = wd;
  if (hour12) {
    if (pm && hour < 12)
      tm.tm.tm_hour = hour + 12;
    else if (!pm && hour == 12)
      tm.tm.tm_hour = 0;
    else
      tm.tm.tm_hour = hour;
  } else {
    tm.tm.tm_hour = hour;
  }
  tm.tm.tm_min = min;
  tm.tm.tm_sec = sec;
  if (!checkTm(&tm.tm)) return -2;
  if (tzHour < -13 || tzHour > 13) return -2;
  tm.fsec = ms * 1000000 + us * 1000 + ns;
  int32_t ret = taosTm2Ts(&tm, ts, precision, tz);
  if (tzHour != 0) {
#ifdef WINDOWS
    int32_t gmtoff = -_timezone;
#elif defined(TD_ASTRA)
    int32_t gmtoff = -timezone;
#else
    int32_t gmtoff = tm.tm.tm_gmtoff;
#endif
    *ts += (gmtoff - tzHour * 3600) * TICK_PER_SECOND[precision];
  }
  return ret;
}

int32_t taosTs2Char(const char* format, SArray** formats, int64_t ts, int32_t precision, char* out, int32_t outLen, timezone_t tz) {
  if (!*formats) {
    *formats = taosArrayInit(8, sizeof(TSFormatNode));
    if (!*formats) {
      TAOS_RETURN(terrno);
    }
    TAOS_CHECK_RETURN(parseTsFormat(format, *formats));
  }
  struct STm tm;
  TAOS_CHECK_RETURN(taosTs2Tm(ts, precision, &tm, tz));
  return tm2char(*formats, &tm, out, outLen);
}

int32_t taosChar2Ts(const char* format, SArray** formats, const char* tsStr, int64_t* ts, int32_t precision,
                    char* errMsg, int32_t errMsgLen, timezone_t tz) {
  const char* sErrPos;
  int32_t     fErrIdx;
  if (!*formats) {
    *formats = taosArrayInit(4, sizeof(TSFormatNode));
    if (!*formats) {
      TAOS_RETURN(terrno);
    }
    TAOS_CHECK_RETURN(parseTsFormat(format, *formats));
  }
  int32_t code = char2ts(tsStr, *formats, ts, precision, &sErrPos, &fErrIdx, tz);
  if (code == -1) {
    TSFormatNode* fNode = (taosArrayGet(*formats, fErrIdx));
    snprintf(errMsg, errMsgLen, "mismatch format for: %s and %s", sErrPos,
             fErrIdx < taosArrayGetSize(*formats) ? ((TSFormatNode*)taosArrayGet(*formats, fErrIdx))->key->name : "");
    code = TSDB_CODE_FUNC_TO_TIMESTAMP_FAILED_FORMAT_ERR;
  } else if (code == -2) {
    snprintf(errMsg, errMsgLen, "timestamp format error: %s -> %s", tsStr, format);
    code = TSDB_CODE_FUNC_TO_TIMESTAMP_FAILED_TS_ERR;
  } else if (code == -3) {
    snprintf(errMsg, errMsgLen, "timestamp format not supported");
    code = TSDB_CODE_FUNC_TO_TIMESTAMP_FAILED_NOT_SUPPORTED;
  }
  TAOS_RETURN(code);
}

int32_t TEST_ts2char(const char* format, int64_t ts, int32_t precision, char* out, int32_t outLen) {
  int32_t code = TSDB_CODE_SUCCESS;

  SArray* formats = taosArrayInit(4, sizeof(TSFormatNode));
  if (!formats) {
    TAOS_RETURN(terrno);
  }
  TAOS_CHECK_RETURN(parseTsFormat(format, formats));
  struct STm tm;
  TAOS_CHECK_GOTO(taosTs2Tm(ts, precision, &tm, NULL), NULL, _exit);
  TAOS_CHECK_GOTO(tm2char(formats, &tm, out, outLen), NULL, _exit);

_exit:
  taosArrayDestroy(formats);
  TAOS_RETURN(TSDB_CODE_SUCCESS);
}

int32_t TEST_char2ts(const char* format, int64_t* ts, int32_t precision, const char* tsStr) {
  const char* sErrPos;
  int32_t     fErrIdx;
  SArray*     formats = taosArrayInit(4, sizeof(TSFormatNode));
  TAOS_CHECK_RETURN(parseTsFormat(format, formats));
  int32_t code = char2ts(tsStr, formats, ts, precision, &sErrPos, &fErrIdx, NULL);
  if (code == -1) {
    (void)printf("failed position: %s\n", sErrPos);
    (void)printf("failed format: %s\n", ((TSFormatNode*)taosArrayGet(formats, fErrIdx))->key->name);
  }
  taosArrayDestroy(formats);
  return code;
}

static int8_t UNIT_INDEX[26] = {/*a*/ 2,  0,  -1, 6,  -1, -1, -1,
                                /*h*/ 5,  -1, -1, -1, -1, 4,  8,
                                /*o*/ -1, -1, -1, -1, 3,  -1,
                                /*u*/ 1,  -1, 7,  -1, 9,  -1};

#define GET_UNIT_INDEX(idx) UNIT_INDEX[(idx)-97]

// clang-format off
static int64_t UNIT_MATRIX[10][11] = {     /*  ns,   us,   ms,    s,   min,   h,   d,   w, month, y*/
                                /*ns*/ {   1, 1000,    0},
                                /*us*/ {1000,    1, 1000,    0},
                                /*ms*/ {   0, 1000,    1, 1000,    0},
                                 /*s*/ {   0,    0, 1000,    1,   60,    0},
                               /*min*/ {   0,    0,    0,   60,    1,   60,   0},
                                 /*h*/ {   0,    0,    0,    0,   60,    1,   1,   0},
                                 /*d*/ {   0,    0,    0,    0,    0,   24,   1,   7,   1,   0},
                                 /*w*/ {   0,    0,    0,    0,    0,    0,   7,   1,  -1,   0},
                               /*mon*/ {   0,    0,    0,    0,    0,    0,   0,   0,   1,  12,  0},
                                 /*y*/ {   0,    0,    0,    0,    0,    0,   0,   0,   12,   1,  0}};
// clang-format on

static bool recursiveTsmaCheckRecursive(int64_t baseInterval, int8_t baseIdx, int64_t interval, int8_t idx,
                                        bool checkEq) {
  if (UNIT_MATRIX[baseIdx][idx] == -1) return false;
  if (baseIdx == idx) {
    if (interval < baseInterval) return false;
    if (checkEq && interval == baseInterval) return false;
    return interval % baseInterval == 0;
  }
  int8_t  next = baseIdx + 1;
  int64_t val = UNIT_MATRIX[baseIdx][next];
  while (val != 0 && next <= idx) {
    if (val == -1) {
      next++;
      val = UNIT_MATRIX[baseIdx][next];
      continue;
    }
    if (val % baseInterval == 0 || baseInterval % val == 0) {
      int8_t extra = baseInterval >= val ? 0 : 1;
      bool   needCheckEq = baseInterval >= val && !(baseIdx < next && val == 1);
      if (!recursiveTsmaCheckRecursive(baseInterval / val + extra, next, interval, idx, needCheckEq && checkEq)) {
        next++;
        val = UNIT_MATRIX[baseIdx][next];
        continue;
      } else {
        return true;
      }
    } else {
      return false;
    }
  }
  return false;
}

static bool recursiveTsmaCheckRecursiveReverse(int64_t baseInterval, int8_t baseIdx, int64_t interval, int8_t idx,
                                               bool checkEq) {
  if (UNIT_MATRIX[baseIdx][idx] == -1) return false;

  if (baseIdx == idx) {
    if (interval < baseInterval) return false;
    if (checkEq && interval == baseInterval) return false;
    return interval % baseInterval == 0;
  }

  int8_t  next = baseIdx - 1;
  int64_t val = UNIT_MATRIX[baseIdx][next];
  while (val != 0 && next >= 0) {
    return recursiveTsmaCheckRecursiveReverse(baseInterval * val, next, interval, idx, checkEq);
  }
  return false;
}

/*
 * @breif check if tsma with param [interval], [unit] can create based on base tsma with baseInterval and baseUnit
 * @param baseInterval, baseUnit, interval/unit of base tsma
 * @param interval the tsma interval going to create. Not that if unit is not calander unit, then interval has already
 * been translated to TICKS of [precision]
 * @param unit the tsma unit going to create
 * @param precision the precision of this db
 * @param checkEq pass true if same interval is not acceptable, false if acceptable.
 * @ret true the tsma can be created, else cannot
 * */
bool checkRecursiveTsmaInterval(int64_t baseInterval, int8_t baseUnit, int64_t interval, int8_t unit, int8_t precision,
                                bool checkEq) {
  bool baseIsCalendarDuration = IS_CALENDAR_TIME_DURATION(baseUnit);
  if (!baseIsCalendarDuration) {
    if (TSDB_CODE_SUCCESS != convertTimeFromPrecisionToUnit(baseInterval, precision, baseUnit, &baseInterval)) {
      return false;
    }
  }
  bool isCalendarDuration = IS_CALENDAR_TIME_DURATION(unit);
  if (!isCalendarDuration) {
    if (TSDB_CODE_SUCCESS != convertTimeFromPrecisionToUnit(interval, precision, unit, &interval)) {
      return false;
    }
  }

  bool needCheckEq = baseIsCalendarDuration == isCalendarDuration && checkEq;

  int8_t baseIdx = GET_UNIT_INDEX(baseUnit), idx = GET_UNIT_INDEX(unit);
  if (baseIdx <= idx) {
    return recursiveTsmaCheckRecursive(baseInterval, baseIdx, interval, idx, needCheckEq);
  } else {
    return recursiveTsmaCheckRecursiveReverse(baseInterval, baseIdx, interval, idx, checkEq);
  }
  return true;
}

int64_t taosGetTimestampToday(int32_t precision, timezone_t tz) {
  int64_t   factor =  (precision == TSDB_TIME_PRECISION_SECONDS) ? 1
                    : (precision == TSDB_TIME_PRECISION_MILLI)   ? 1000
                    : (precision == TSDB_TIME_PRECISION_MICRO)   ? 1000000
                    : 1000000000;
  time_t    t;
  int32_t code = taosTime(&t);
  if (code != 0) {
    return -1;
  }
  struct tm tm;
  if (taosLocalTime(&t, &tm, NULL, 0,  tz) == NULL){
    uError("%s failed to get local time, code:%d", __FUNCTION__, ERRNO);
    return t;
  }
  tm.tm_hour = 0;
  tm.tm_min = 0;
  tm.tm_sec = 0;

  time_t tmp = taosMktime(&tm, tz);
  if (tmp == (time_t)-1) {
    uError("%s failed to get timestamp of today, code:%d", __FUNCTION__, ERRNO);
    return t;
  }
  return (int64_t)tmp * factor;
}

taosdata / TDengine / #4720

Source File Press 'n' to go to next uncovered line, 'b' for previous

Source File
Press 'n' to go to next uncovered line, 'b' for previous