その他の関数

  Excel、MDB



  
select
	Round(123.456) as 四捨五入1
	,Round(123.456,2) as 四捨五入2
	,Fix(123.456) as 切捨て
	,Format(123456,'#,###') as 数値編集1
	,Format(123456,'#,##0') as 数値編集2
	,Instr('ABCDEFG','CDE') as 文字列検索
	,UCase('abc') as 大文字
	,LCase('ABC') as 小文字
	,10 MOD 4 as 余り
  

四捨五入1四捨五入2切捨て数値編集1数値編集2文字列検索大文字小文字余り
123123.46123123,456123,4563ABCabc2





  SQLServer



  
select
	ROUND(123.456,0) as 四捨五入1
	,ROUND(123.456,1) as 四捨五入2
	,ROUND(123.456,-1) as 四捨五入2
	,ROUND(123.456,0,1) as 切捨て1
	,ROUND(123.456,2,1) as 切捨て2
	,ROUND(123.456,-1,1) as 切捨て3
	,PATINDEX('%CDE%', 'ABCDEFG') as 文字列検索
	,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
	,UPPER('abc') as 大文字
	,LOWER('ABC') as 小文字
	,10 % 4  as 余り
	,REPLACE(CONVERT(VARCHAR(20),CONVERT(money,123456),1),'.00','') as 整数編集
  

四捨五入1四捨五入2四捨五入2切捨て1切捨て2切捨て3文字列検索文字列置換大文字小文字余り整数編集
123123.5120123123.451203ABxxxFGABCabc2123,456





  MySQL

  
select
	ROUND(123.456) as 四捨五入1
	,ROUND(123.456,2) as 四捨五入2
	,ROUND(123.456,-1) as 四捨五入3
	,TRUNCATE(123.456,1) as 切捨て1
	,TRUNCATE(123.456,-1) as 切捨て2
	,LPAD('ABC','6','0') as 埋め込み1
	,RPAD('ABC','6','0') as 埋め込み2
	,INSTR('ABCDEFG','CDE') as 文字列検索
	,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
	,UPPER('abc') as 大文字
	,LOWER('ABC') as 小文字
	,MOD(10,4) as 余り
  



  PostgreSQL

  
select
	ROUND(123.456) as 四捨五入1
	,ROUND(123.456,2) as 四捨五入2
	,ROUND(123.456,-1) as 四捨五入3
	,TRUNC(123.456) as 切捨て1
	,TRUNC(123.456,2) as 切捨て2
	,TRUNC(123.456,-1) as 切捨て3
	,TO_CHAR(123456,'999,999') as 数値編集
	,TO_CHAR(123,'00000') as 先行ゼロ編集
	,TO_CHAR(12345,'FM9999999999') as 文字列へ変換
	,LPAD('ABC','6','0') as 埋め込み1
	,RPAD('ABC','6','0') as 埋め込み2
	,POSITION('CDE' in 'ABCDEFG') as 文字列検索
	,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
	,UPPER('abc') as 大文字
	,LOWER('ABC') as 小文字
	,MOD(10,4) as 余り
  

四捨五入1四捨五入2四捨五入3切捨て1切捨て2切捨て3数値編集先行ゼロ編集
123123.46120123123.45120123,456123
文字列へ変換埋め込み1埋め込み2文字列検索文字列置換大文字小文字余り
12345000ABCABC0003ABxxxFGABCabc2





  Oracle

  
select
	ROUND(123.456) as 四捨五入1
	,ROUND(123.456,2) as 四捨五入2
	,ROUND(123.456,-1) as 四捨五入3
	,TRUNC(123.456) as 切捨て1
	,TRUNC(123.456,2) as 切捨て2
	,TRUNC(123.456,-1) as 切捨て3
	,TO_CHAR(123456,'999,999') as 数値編集
	,TO_CHAR(123,'00000') as 先行ゼロ編集
	,LPAD('ABC','6','0') as 埋め込み1
	,RPAD('ABC','6','0') as 埋め込み2
	,INSTR('ABCDEFG','CDE') as 文字列検索
	,REPLACE('ABCDEFG','CDE','xxx') as 文字列置換
	,UPPER('abc') as 大文字
	,LOWER('ABC') as 小文字
	,MOD(10,4) as 余り
from dual
  










  infoboard   管理者用   
このエントリーをはてなブックマークに追加




SQLの窓  天気  IT用語辞典
Yahoo!ニュース  マルチ辞書
PHP マニュアル  Google URL短縮 


フリーフォントWEBサービス
SQLの窓WEBサービス

SQLの窓フリーソフト

素材

一般WEBツールリンク

SQLの窓

フリーソフト

JSライブラリ