DB2常用函數(shù)與Oracle有什么不同？

轉(zhuǎn)化為字符串類(lèi)型Oracle:selectto_char(15.5000)fromdual;DB2:selectchar(15.5000)fromsysibm.sysdummy1轉(zhuǎn)化為日期時(shí)間Oracle:selectto_date('2008-01-01','yyyy-mm-dd')fromdual;DB2:selectdate('2008-01-01')fromsysibm.sysdummy12、時(shí)間日期：year,quarter,month,week,day,hour,minute,seconddayofyear(arg):返回arg在年內(nèi)的天值Dayofweek(arg):返回arg在周內(nèi)的天值