为了后续方便查询,后面将总结以下经常用到的sql记录下来方便后续使用。...timestamp))
Hive:select datediff('2020-07-24 11:42:58','2020-07-23 15:01:13');
同比环比
--presto 同环比时间获取公式...TIMESTAMP))-1),date_add('month', - 1, date_trunc('month', CAST('2020-12-12' AS TIMESTAMP)))) as "上月第一天至环比相同天数...",
add_months(TRUNC('2020-12-12', 'MM'), - 12) AS "去年当月第一天",
add_months(TRUNC('2020-12-12', 'MM...-12-12', 'MM'), - 1),day('2020-12-12')-1) as "上月第一天至环比相同天数"
待续...