Oracle 格式转换 to_number(to_char(to_date)) 转换.详细见补充.select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMM')) from dual;原本预期输入 201403 输出 20140201结果实测 输出 201402 .如何
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/08 13:27:53
![Oracle 格式转换 to_number(to_char(to_date)) 转换.详细见补充.select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMM')) from dual;原本预期输入 201403 输出 20140201结果实测 输出 201402 .如何](/uploads/image/z/11906819-35-9.jpg?t=Oracle+%E6%A0%BC%E5%BC%8F%E8%BD%AC%E6%8D%A2+to_number%28to_char%28to_date%29%29+%E8%BD%AC%E6%8D%A2.%E8%AF%A6%E7%BB%86%E8%A7%81%E8%A1%A5%E5%85%85.select+to_number%28to_char%28add_months%28to_date%28to_char%28201403%29%7C%7C%2701%27%2C%27yyyymmdd%27%29+%2C-1%29%2C%27YYYYMM%27%29%29+from+dual%3B%E5%8E%9F%E6%9C%AC%E9%A2%84%E6%9C%9F%E8%BE%93%E5%85%A5+201403+%E8%BE%93%E5%87%BA+20140201%E7%BB%93%E6%9E%9C%E5%AE%9E%E6%B5%8B+%E8%BE%93%E5%87%BA+201402+.%E5%A6%82%E4%BD%95)
Oracle 格式转换 to_number(to_char(to_date)) 转换.详细见补充.select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMM')) from dual;原本预期输入 201403 输出 20140201结果实测 输出 201402 .如何
Oracle 格式转换 to_number(to_char(to_date)) 转换.详细见补充.
select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMM')) from dual;
原本预期输入 201403 输出 20140201
结果实测 输出 201402 .如何破 ,
Oracle 格式转换 to_number(to_char(to_date)) 转换.详细见补充.select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMM')) from dual;原本预期输入 201403 输出 20140201结果实测 输出 201402 .如何
select to_number(to_char(add_months(to_date(to_char(201403)||'01','yyyymmdd') ,-1),'YYYYMMdd')) from dual;
粗心大意,转换了字符串的年月日,但是在转换为date时候又把dd去掉了.