为提高效率,请提供以下信息,问题描述清晰能够更快得到解决:
【TiDB 版本】5.0.0/4.0.11
Release Version: v5.0.0
Edition: Community
Git Commit Hash: bdac0885cd11bdf571aad9353bfc24e13554b91c
Git Branch: heads/refs/tags/v5.0.0
UTC Build Time: 2021-04-06 16:36:29
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
Release Version: v4.0.11
Edition: Community
Git Commit Hash: 058e52ad7c1b477147dcb933b3f1b3b2be31e998
Git Branch: heads/refs/tags/v4.0.11
UTC Build Time: 2021-02-25 04:33:58
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false
【问题描述】 FROM_UNIXTIME 返回空白,与mysql不兼容
例如:navicat11.1.2执行:
SELECT FROM_UNIXTIME( ‘1619850956’ ,‘%Y-%m-%d’);
SELECT FROM_UNIXTIME( UNIX_TIMESTAMP() ,‘%Y-%m-%d’)