informix数据库常用语句
日期截取(extend函数)select datetime from table;--2020-07-07 11:11:11select extend(datetime, year to day) from table;--2020-07-07select extend(datetime, hour to second) from table;--11:11:11注:extend()函数返回datetime类型日期格式化(to_char和to_date函数)select to_c
原创
2020-07-14 11:50:52 ·
796 阅读 ·
0 评论