TO_DATE(DATE_FORMAT(FROM_UNIXTIME(1629244800000 / 1000),'yyyy-MM-dd')) -- 2021-08-18
Flink SQL> select TO_DATE(DATE_FORMAT(FROM_UNIXTIME(1629244800000 / 1000),'yyyy-MM-dd'));
+----+------------+
| op | EXPR$0 |
+----+------------+
| +I | 2021-08-18 |
+----+------------+
Received a total of 1 row
Flink SQL> select TO_DATE(DATE_FORMAT(FROM_UNIXTIME(1629244800000 / 1000),'yyyy-MM-dd'));
+----+------------+
| op | EXPR$0 |
+----+------------+
| +I | 2021-08-18 |
+----+------------+
Received a total of 1 row
本文转载自: https://blog.csdn.net/qq_35515661/article/details/134199961
版权归原作者 Thomas2143 所有， 如有侵权，请联系我们删除。
版权归原作者 Thomas2143 所有， 如有侵权，请联系我们删除。