sql-server和oracle常用函數(shù)對(duì)比(存儲(chǔ)版)
【正文】 d%q%39。abcd39。abcdef39。fa39。abcd39。Smith39。Smithers39。S:可以直接轉(zhuǎn)或者select cast(39。（比如分鐘）S:select dateadd(mi,8,getdate()) valueO:SELECT sysdate+8/60/24 vaule FROM DUAL。時(shí)區(qū)參數(shù),北京在東8區(qū)應(yīng)該是YdtAST ADT 大西洋標(biāo)準(zhǔn)時(shí)間BST BDT 白令海標(biāo)準(zhǔn)時(shí)間CST CDT 中部標(biāo)準(zhǔn)時(shí)間EST EDT 東部標(biāo)準(zhǔn)時(shí)間GMT 格林尼治標(biāo)準(zhǔn)時(shí)間HST HDT 阿拉斯加?夏威夷標(biāo)準(zhǔn)時(shí)間MST MDT 山區(qū)標(biāo)準(zhǔn)時(shí)間NST 紐芬蘭標(biāo)準(zhǔn)時(shí)間PST PDT 太平洋標(biāo)準(zhǔn)時(shí)間YST YDT YUKON標(biāo)準(zhǔn)時(shí)間來源：網(wǎng)絡(luò) 編輯：聯(lián)動(dòng)北方技術(shù)論壇。) vaule FROM DUAL。hh24:mm:ss39。Smythe39。abcd39。abcd39。fasdbfasegas39。ijklmn39。sd39。s39。2239。1139。數(shù)學(xué)函數(shù)S:select abs(1) valueO:select abs(1) value from dual(大)S:select ceiling() valueO:select ceil() value from dual（?。㏒:select floor() valueO:select floor() value from dual（截?。㏒:select cast( as int) valueO:select trunc() value from dualS:select round(,4) value O:select round(,4) value from dual S:select Exp(1) value O:select Exp(1) value from dual S:se
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1