【informix】informix 日期字段

 informix 获取当前时间，时间格式

-- 默认 YYYY - MM - DD

select today from dual;
 
-- 格式 YYYY - MM - DD HH:mm:ss:000

select current from dual;
 
-- 格式 YYYY/MM/DD

select to_char(current,'%Y/%m/%d') from dual;
 
-- 格式 HHmmss

select 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