Inceptor 日期函數(shù)之 時(shí)間獲取與轉(zhuǎn)換

Inceptor 可以理解成 Hive，Inceptor 的日期函數(shù)基本兼容 Hive。
從哪個(gè) SQL 體系轉(zhuǎn)過來都可以很快適應(yīng) Inceptor 語法

• 獲取當(dāng)前日期和時(shí)間

SELECT 
 systimestamp AS 完整時(shí)間  --yyyy-MM-dd HH:mm:ss
,sysdate AS 日期          --yyyy-MM-dd
,systime AS 時(shí)間          --HH:mm:ss
FROM system.dual LIMIT 1;

image.png

• 獲取當(dāng)前時(shí)間戳：Int

SELECT unix_timestamp() AS result FROM system.dual LIMIT 1;

image.png

• ?時(shí)間??unix時(shí)間戳

SELECT 
 to_timestamp('2021-04-25 10:10:50') AS result1
,to_unix_timestamp('2021-04-25 10:10:50') AS result2
,unix_timestamp('2021-04-25 10:10:50') AS result3
FROM system.dual LIMIT 1;

image.png

-- 不填參數(shù)默認(rèn)獲取當(dāng)前時(shí)間戳
SELECT unix_timestamp() AS result FROM system.dual LIMIT 1;

• 日期??unix時(shí)間戳?

SELECT 
 from_unixtime(1619316650, 'yyyy-MM-dd') AS 日期
,from_unixtime(1619316650, 'HH:mm:ss') AS 時(shí)間
,from_unixtime(1619316650, 'yyyy-MM-dd HH:mm:ss') AS 完整時(shí)間
,from_unixtime(CAST(1619316650000/1000 AS int)) AS 特殊處理帶毫秒的時(shí)間
FROM system.dual LIMIT 1;

image.png