常用日期函数实例
hive (default)> select unix_timestamp();
unix_timestamp(void) is deprecated. Use current_timestamp instead.
OK
_c0
1607595857
Time taken: 0.026 seconds, Fetched: 1 row(s)
hive (default)> select unix_timestamp('2018-08-08 08:08:08');
OK
_c0
1533686888
Time taken: 0.027 seconds, Fetched: 1 row(s)
hive (default)> select from_unixtime(1533686888);
OK
_c0
2018-08-08 08:08:08
Time taken: 0.876 seconds, Fetched: 1 row(s)
hive (default)> select current_date();
OK
_c0
2020-12-10
Time taken: 0.026 seconds, Fetched: 1 row(s)
hive (default)> select current_timestamp();
OK
_c0
2020-12-10 18:33:31.264
Time taken: 0.027 seconds, Fetched: 1 row(s)