static int varchar_datetime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out) { int ret = OB_SUCCESS; UNUSED(params); OB_ASSERT(in.get_type() == ObVarcharType); int year = 0; int month = 0; int day = 0; int hour = 0; int minute = 0; int second = 0; ret = varchar_scanf(in, 6, "%4d-%2d-%2d %2d:%2d:%2d", &year, &month, &day, &hour, &minute, &second); if (OB_SUCCESS != ret) { year = month = day = hour = minute = second = 0; ret = varchar_scanf(in, 3, "%4d-%2d-%2d", &year, &month, &day); } if (OB_SUCCESS != ret) { year = month = day = hour = minute = second = 0; ret = varchar_scanf(in, 3, "%2d:%2d:%2d", &hour, &minute, &second); } if (OB_SUCCESS == ret) { struct tm gtm; memset(>m, 0, sizeof (gtm)); gtm.tm_year = year - 1900; gtm.tm_mon = month - 1; gtm.tm_mday = day; gtm.tm_hour = hour; gtm.tm_min = minute; gtm.tm_sec = second; time_t t = mktime(>m); out.set_datetime(static_cast<ObDateTime> (t)); } else { const string& varchar = in.get_varchar(); jlog(WARNING, "failed to convert string `%.*s' to datetime type", varchar.length(), varchar.data()); out.set_datetime(static_cast<ObDateTime> (0)); ret = OB_SUCCESS; } return ret; }
static int bool_datetime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out) { UNUSED(params); OB_ASSERT(in.get_type() == ObBoolType); out.set_datetime(static_cast<ObDateTime> (in.get_bool())); return OB_SUCCESS; }
static int mtime_datetime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out) { UNUSED(params); OB_ASSERT(in.get_type() == ObModifyTimeType); out.set_datetime(static_cast<ObDateTime> (in.get_mtime() / 1000000L)); return OB_SUCCESS; }
TEST_F(ObObjCastTest, datetime_to_xxx) { ObExprObj in; //tzset(); //printf("timezone=%s %s\n", tzname[0], tzname[1]); const char* cases_str[] = {"1970-1-1 8:0:0", "1970-1-1 0:0:0", "2012-9-24 16:59:60"}; time_t cases[ARRAYSIZEOF(cases_str)]; const char *varchar_expected[] = {"1970-01-01 08:00:00", "1970-01-01 00:00:00", "2012-09-24 17:00:00"}; const char *dec_expected[] = {"0", "-28800", "1348477200"}; for (int64_t i = 0; i < static_cast<int64_t>(ARRAYSIZEOF(cases)); ++i) { struct tm tm; memset(&tm, 0, sizeof(tm)); strptime(cases_str[i], "%Y-%m-%d %H:%M:%S", &tm); cases[i] = mktime(&tm); time_t v = cases[i]; //printf("v=%s", ctime(&v)); int64_t pv = v * 1000000L; in.set_datetime(v); MY_EXPECT(ObDateTimeType, in, ObNullType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObIntType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObFloatType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObDoubleType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObDateTimeType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObPreciseDateTimeType, pv, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObVarcharType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObSeqType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObCreateTimeType, pv, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObModifyTimeType, pv, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObExtendType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObBoolType, v, varchar_expected[i]); MY_EXPECT(ObDateTimeType, in, ObDecimalType, v, dec_expected[i]); } }
static int decimal_datetime(const ObObjCastParams ¶ms, const ObExprObj &in, ObExprObj &out) { int ret = OB_SUCCESS; UNUSED(params); OB_ASSERT(in.get_type() == ObDecimalType); int64_t i64 = 0; if (OB_SUCCESS != (ret = in.get_decimal().cast_to_int64(i64))) { jlog(WARNING, "failed to cast to int64, err=%d", ret); } else { out.set_datetime(static_cast<ObDateTime> (i64)); } return ret; }