鍦ㄦ暟鎹簱涓紝CONVERT鍑芥暟鐢ㄤ簬灏嗕竴涓暟鎹被鍨嬭浆鎹负鍙︿竴涓暟鎹被鍨嬨€傚畠鐨勮娉曢€氬父濡備笅锛?/p>

CONVERT(data_type, expression, style)

鍏朵腑锛宒ata_type琛ㄧず瑕佽浆鎹㈢殑鐩爣鏁版嵁绫诲瀷锛宔xpression琛ㄧず瑕佽浆鎹㈢殑琛ㄨ揪寮忔垨鍒楋紝style鏄彲閫夌殑锛岀敤浜庢寚瀹氳浆鎹㈡牱寮忋€?/p>

浠ヤ笅鏄竴浜涘父瑙佺殑浣跨敤绀轰緥锛?/p>

1. 灏嗕竴涓瓧绗︿覆杞崲涓烘暣鏁帮細

SELECT CONVERT(INT, 鈥?23鈥? AS ConvertedValue;

2. 灏嗕竴涓暣鏁拌浆鎹负瀛楃涓诧細

SELECT CONVERT(VARCHAR, 456) AS ConvertedValue;

3. 灏嗕竴涓棩鏈熷瓧绗︿覆杞崲涓烘棩鏈熺被鍨嬶細

SELECT CONVERT(DATE, 鈥?022-01-01鈥? AS ConvertedDate;

4. 灏嗕竴涓棩鏈熺被鍨嬭浆鎹负瀛楃涓诧細

SELECT CONVERT(VARCHAR, GETDATE(), 101) AS ConvertedDate;

鍦ㄥ疄闄呬娇鐢ㄤ腑锛屽叿浣撶殑杞崲鏂瑰紡鍜屾牱寮忓彲鑳戒細鏈夋墍涓嶅悓锛屽叿浣撳彇鍐充簬鏁版嵁搴撶鐞嗙郴缁熺殑涓嶅悓浠ュ強闇€瑕佺殑杞崲绫诲瀷銆傚洜姝わ紝寤鸿鏌ラ槄鏁版嵁搴撶鐞嗙郴缁熺殑鏂囨。浠ヨ幏鍙栨洿璇︾粏鐨勪俊鎭€?/p>