sql-server和oracle常用函數(shù)對比(更新版)
【正文】 DEX(39。,2) value from dual 返回2,參數(shù)去掉中間%則返回7S:select patindex(39。,1,2) value from dual 返回6S:select substring(39。) valueO:SELECT Replace(39。,39。 valueO:select LPAD(39。,2) valueO:沒發(fā)現(xiàn)(這兩個單詞返回值一樣，發(fā)音相同)S:SELECT SOUNDEX (39。) from dualSQLServer中用SELECT DIFFERENCE(39。) value from dualS:DATEPART 和 DATENAME 函數(shù) （第一個參數(shù)決定）O:to_char函數(shù) 第二個參數(shù)決定參數(shù)下表需要補充year yy, yyyyquarter qq, q (季度)month mm, m (m O無效)dayofyear dy, y (O表星期)day dd, d (d O無效)week wk, ww (wk O無效)weekday dw (O不清楚)Hour hh,hh12,hh24 (hh12,hh24 S無效)minute mi, n (n O無效)second ss, s (s O無效)millisecond ms (O無效)S:不知道O:select LAST_DAY(sysdate) value from dual（比如星期日）S:不知道O:SELECT Next_day(sysdate,7) vaule FROM DUAL。（比如秒）S:select datediff(ss,getdate(),getdate()+) valueO:直接用兩個日期相減（比如d1d2=）SELECT (d1d2)*24*60*60 vaule FROM D
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1