1.字符串转换成时间类型 to_timestamp()
例:SELECT to_timestamp('202207201500','YYYYMMDDHH24MI')、SELECT to_timestamp(cast(202207201500 AS TEXT),'YYYYMMDD')
2.字符串转化成时间类型 to_date()
例:SELECT to_date('202207101800','YYYYMMDDHH24MI')、SELECT to_date('202207101800','YYYYMMDD')
3.时间类型转化成字符串 to_char()
例:SELECT to_char(NOW(),'YYYYMMDDHH24MI')、SELECT to_char(NOW(),'YYYY-MM-DD')
4.获取当前时间 now() 获取当前日期 current_date
例:SELECT now SELECT current_date
5.时间计算 减一天:-day 减一小时:-1h 减一分钟:-1minute 减一秒:-1s
例:SELECT now() - TIME '00:20'、SELECT to_char(current_date-1,'YYYYMMDD')、SELECT to_char(now() - INTERVAL '1440 MINUTE','YYYYMMDDHH24MI')、SELECT current_date - INTERVAL '1 day'