informix 獲取日期方法
select mdy(month(today-day(today) units day),1,year(today-day(today) units day)) from 表名 (獲取上月第一天)//2021-11-01select mdy(11,1,2021) from 表名//2021-11-01select today-1 units month from 表名 (獲取上月最後一天)//2021-11-30select today-day(today)+1 units da
原创
2021-12-01 10:14:15 ·
1447 阅读 ·
0 评论