INFORMIX后台关于日期的语句
答案:1 悬赏:40 手机版
解决时间 2021-11-17 22:42
- 提问者网友：绫月
- 2021-11-17 02:23
INFORMIX后台关于日期的语句
最佳答案
- 五星知识达人网友：一叶十三刺
- 2021-11-17 03:57
当月第一天：mdy(month (today),01,year (today))
当年第一天：mdy(01,01,year(today))
select * from xxx
where date >= mdy(month (today),01,year (today))
and date <=today;
select * from xxx
where date >= mdy(01,01,year(today))
and date <=today;
当年第一天：mdy(01,01,year(today))
select * from xxx
where date >= mdy(month (today),01,year (today))
and date <=today;
select * from xxx
where date >= mdy(01,01,year(today))
and date <=today;
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯