?????? ????from_unixtime????????????

[????]

????????master??????????????????????????
??????


 




------------------ ???????? ------------------
??????:&nbsp;"Zhao Chun"<zh...@apache.org&gt;;
????????:&nbsp;2020??6??10??(??????) ????5:36
??????:&nbsp;"dev"<dev@doris.apache.org&gt;;

????:&nbsp;Re: ????from_unixtime????????????



What's the version of your Doris.
This problem has been fixed, you can upgrade your Doris to master and then
check it.

Thanks,
Zhao Chun


???? <920555...@qq.com&gt; ??2020??6??10?????? ????3:44??????

&gt; ??????????????????
&gt; 
????????????????????doris????from_unixtime????????????????????????????????????????????????????????
&gt;
&gt;
&gt; mysql&amp;gt; select count(installed_at) from table_xx;
&gt; +-----------------------+
&gt; | count(`installed_at`) |
&gt; +-----------------------+
&gt; |&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 
&amp;nbsp; &amp;nbsp;3208506 |
&gt; +-----------------------+
&gt; 1 row in set (0.77 sec)
&gt;
&gt;
&gt; mysql&amp;gt; select count(from_unixtime(installed_at)) from table_xx;
&gt; +--------------------------------------+
&gt; | count(from_unixtime(`installed_at`)) |
&gt; +--------------------------------------+
&gt; |&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;
&gt; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 3208506 |
&gt; +--------------------------------------+
&gt; 1 row in set (2 min 14.86 sec)
&gt;
&gt; &amp;nbsp;
&gt; ??????????????????installed_at????????int(10), ??????time_zone