informix 获取当前时间,时间格式
-- 默认 YYYY - MM - DD
select today from dual;
-- 格式 YYYY - MM - DD HH:mm:ss:000select current from dual;
-- 格式 YYYY/MM/DDselect to_char(current,'%Y/%m/%d') from dual;
-- 格式 HHmmssselect to_char(current, '%H%M%S') from dual;
-- 格式 yy-mm-dd
select TO_CHAR(today,'%y-%m-%d') from dual;
-- 格式 Monday August mm YYYY
select TO_CHAR(today,'%A %B %d %Y') from dual;
select YEAR(today), MONTH(today) from dual;
结果
ADD_MONTHS(today, 3)
// 当前月份往后推3个月
select to_char(ADD_MONTHS(current, 3), '%Y%m') from dual;
结果
1、extend
start_time='2020-08-28 22:12:13'
extend(start_time,year to month)='2020-08'
extend(start_time,hour to hour)='22'
2、to_date
用法类似于to_char,to_date('20200828221543','%Y%m%d%H%M%S')
将返回1个 datetime 型:2020-08-28 22:15:43.00000