??????????????????
????????????????????doris????from_unixtime????????????????????????????????????????????????????????


mysql> select count(installed_at) from table_xx;
+-----------------------+
| count(`installed_at`) |
+-----------------------+
|               3208506 |
+-----------------------+
1 row in set (0.77 sec)


mysql> select count(from_unixtime(installed_at)) from table_xx;
+--------------------------------------+
| count(from_unixtime(`installed_at`)) |
+--------------------------------------+
|                      
        3208506 |
+--------------------------------------+
1 row in set (2 min 14.86 sec)

 
??????????????????installed_at????????int(10), ??????time_zone

Reply via email to