sql-server和oracle常用函數(shù)對(duì)比(專業(yè)版)
【正文】 （比如秒）S:select datediff(ss,getdate(),getdate()+) valueO:直接用兩個(gè)日期相減（比如d1d2=）SELECT (d1d2)*24*60*60 vaule FROM DUAL。) from dualSQLServer中用SELECT DIFFERENCE(39。 valueO:select LPAD(39。) valueO:SELECT Replace(39。,2) value from dual 返回2,參數(shù)去掉中間%則返回7S:select patindex(39。+39。a39。sdsq39。abcdef39。abcd dsaf df39。Smith39。,39。ydt39。Smythers39。abcd39。bcd39。sdsfasdqe39。3339。S:select sign(8) value 1O:select sign(8) value from dual 1S:SELECT PI() value O:不知道,cos,tan 參數(shù)都以弧度為單位例如：select sin(PI()/2) value 得到1（SQLServer）,Acos,Atan,Atan2 返回弧度(SQLServer，Oracle不知道)DEGREES：弧度〉角度RADIANS：角度〉弧度數(shù)值間比較18. 求集合最大值S:select max(value) value from(select 1 valueunionselect 2 valueunionselect 4 valueunionselect 3 value)aO:select greatest(1,2,4,3) value from dual19. 求集合最小值S:select min(value) value from(select 1 valueunionselect 2
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1