SQL 髢｢謨ｰｼ壽焚蛟､髢｢謨ｰ
荳隕ｧ
蝗帶昏莠泌･
窶ｻ螳溯｡梧｡∵焚 ｼ 蝗帶昏莠泌･蠕後ｮ蟆乗焚轤ｹ莉･荳九ｮ陦ｨ遉ｺ謨ｰ
竍貞ｮ溯｡梧｡∵焚縺ｮ譖ｴ縺ｫ荳九ｮ譯√ｮ蝗帶昏莠泌･繧定｡後≧
ROUND(555.555, 1) 竍555.6
ROUND(555.555, 2) 竍555.56
ROUND(555.554, 2) 竍555.55
ROUND(蟇ｾ雎｡)
窶ｻROUND(ｽ,0)縺ｨ蜷後§
ROUND(555) 竍555
ROUND(555.55) 竍556
ROUND(555.40) 竍555
譌･譎ゅｮ蝗帶昏莠泌･
窶ｻ萓具ｼ啌OUND('15-06-22 17:30:30', 'ｽ')
蝗帶昏莠泌･繝ｫ繝ｼ繝ｫ
譎る俣ｼ夲ｽ11譎や貞ｽ捺律/12譎ゑｽ樞堤ｿ梧律
譌･ｼ夲ｽ15譌･竊貞ｽ捺怦/16譌･ｽ樞堤ｿ梧怦
譛茨ｼ夲ｽ6譛遺貞ｽ灘ｹｴ/7譛茨ｽ樞堤ｿ悟ｹｴ
ROUND(譌･譎) 窶ｻ蠑墓焚逵∫払譎
ｼ抒OUND(譌･譎, 'DD')
ROUND(譌･譎, 'YYYY')
竊15-01-01 00:00:00
ROUND(譌･譎, 'MM')
竊15-07-01 00:00:00
ROUND(譌･譎, 'DD')
竊15-06-23 00:00:00
ROUND(譌･譎, 'HH')
竊15-06-22 17:00:00
窶ｻ螳溯｡梧｡∵焚 ｼ 蝗帶昏莠泌･蠕後ｮ蟆乗焚轤ｹ莉･荳九ｮ陦ｨ遉ｺ謨ｰ
ROUND(145.50 , 0 ) 竍 146.00(145.50)
ROUND(145.45 , 0) 竍 145.00(145.45)
ROUND(-145.50 , 0) 竍 -146.00(-145.50)
ROUND(-145.45 , 0) 竍 -145.00(-145.45)
ROUND(145.45 , 1) 竍 145.50(145.45)
ROUND(145.45 , 2) 竍 145.45(145.45[])
ROUND(145.45 , -1) 竍 150.00(145.45)
ROUND(145.45 , -2) 竍 100.00(145.45)
蛻繧頑昏縺ｦ
TRUNC(蟇ｾ雎｡縲∝ｮ溯｡梧｡∵焚)
窶ｻ螳溯｡梧｡∵焚 ｼ 蛻繧頑昏縺ｦ蠕後ｮ蟆乗焚轤ｹ莉･荳九ｮ陦ｨ遉ｺ謨ｰ
竍貞ｮ溯｡梧｡∵焚縺ｮ譖ｴ縺ｫ荳九ｮ譯√ｮ蛻繧頑昏縺ｦ繧定｡後≧
TRUNC(555.555, 1) 竍555.5
TRUNC(555.555, 2) 竍555.55
TRUNC(555.559, 2) 竍555.55
TRUNC(蟇ｾ雎｡)
窶ｻTRUNC(ｽ,0)縺ｨ蜷後§
TRUNC(555) 竍555
TRUNC(555.55) 竍555
TRUNC(555.99) 竍555
譌･譎ゅｮ蛻繧頑昏縺ｦ
窶ｻ萓具ｼ啜RUNC('15-06-22 17:30:30', 'ｽ')
TRUNC(譌･譎) 窶ｻ蠑墓焚逵∫払譎
ｼ抖RUNC(譌･譎, 'DD')
TRUNC(譌･譎, 'YYYY')
竊15-01-01 00:00:00
TRUNC(譌･譎, 'MM')
竊15-06-01 00:00:00
TRUNC(譌･譎, 'DD')
竊15-06-22 00:00:00
TRUNC(譌･譎, 'HH')
竊15-06-22 17:00:00
TRUNC(譌･譎, 'MI')
竊15-06-22 17:30:00
TRUNC(譌･譎, 'SS')
竊偵お繝ｩ繝ｼ
菴吶ｊ
Follow me!
