当前位置：网站首页>Use of Presto date function

Use of Presto date function

2022-04-23 12:57:00 【Look at the data at the top of the mountain】 

date_diff()： Find the difference between the two times , Inside are two time stamps , Back - front = Difference value 
eg：date_diff('day',from_iso8601_timestamp('2021-12-23'),from_unixtime(ctime/1000)) as gap
)： In days 

from_iso8601_timestamp(): Convert a date to a timestamp 
eg：from_iso8601_timestamp('2021-12-23') =>2021-12-23 00:00:00.000 Asia/Shanghai 

from_unixtime(): Format the date 
eg：from_unixtime(ctime/1000)) => 2021-12-22 13:54:07.000 

date_parse(): Format the date of the string 
eg：date_parse(t2.logday,'%Y%m%a')
 The original logday yes 20211223, Now it turns into 2021-12-23
select date_parse('20211222', '%Y%m%d'); =>2021-12-22 00:00:00.000

版权声明
本文为[Look at the data at the top of the mountain]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230615025044.html

边栏推荐

猜你喜欢

随机推荐