Greenplum常用语法记录
1、查询UNIX纪元
1 2 | select date_part('epoch',CAST('2018-02-09 19:25:00' AS TIMESTAMP));//写法一 SELECT EXTRACT(epoch FROM CAST('2018-02-09 19:25:00' AS TIMESTAMP));//写法二 |
2、UNIX纪元转换为时间戳
1 | select to_timestamp(1519873379); |
3、时间戳转换为字符格式时间
1 | select to_char(current_timestamp,'YYYY-MM-DD'); |