DB2常用函数与Oracle有什么不同?
转化为字符串类型Oracle:selectto_char(15.5000)fromdual;DB2:selectchar(15.5000)fromsysibm.sysdummy1转化为日期时间Oracle:selectto_date('2008-01-01','yyyy-mm-dd')fromdual;DB2:selectdate('2008-01-01')fromsysibm.sysdummy12、时间日期:year,quarter,month,week,day,hour,minute,seconddayofyear(arg):返回arg在年内的天值Dayofweek(arg):返回arg在周内的天值