CONVERT

Misol

Ifodani int tipiga o‘giring:

SELECT CONVERT(int, 25.65);

O‘zingiz sinab ko‘ring »

Ta’rif va qo‘llanilishi

CONVERT() funksiyasi (istalgan tipdagi) qiymatni ko‘rsatilgan ma’lumot tipiga o‘giradi.

Maslahat: CAST() funksiyasiga ham qarang.

Sintaksis

CONVERT(data_type(length), expression, style)

Parametr qiymatlari

Qiymat

Tavsif

data_type

Majburiy. Ifodani aylantirish uchun ma’lumotlar turi. Quyidagilardan biri bo‘lishi mumkin: bigint, int, smallint, tinyint, bit, o‘nlik, raqamli, pul, smallmoney, float, real, datetime, smalldatetime, char, varchar, text, nchar, nvarchar, ntext, binar, varbinary yoki image

(length)

Ixtiyoriy. Natijaviy ma’lumot tipining uzunligi (char, varchar, nchar, nvarchar, binary va varbinary uchun)

expression

Majburiy. Boshqa ma’lumotlar turiga aylantiriladigan qiymat

style

Optional. The format used to convert between data types, such as a date or string format. Can be one of the following values:

Converting datetime to character:

Without century	Asr bilan	Input/Output	Standard
0	100	mon dd yyyy hh:miAM/PM	Default
1	101	mm/dd/yyyy	US
2	102	yyyy.mm.dd	ANSI
3	103	dd/mm/yyyy	British/French
4	104	dd.mm.yyyy	German
5	105	dd-mm-yyyy	Italian
6	106	dd mon yyyy	-
7	107	Mon dd, yyyy	-
8	108	hh:mm:ss	-
9	109	mon dd yyyy hh:mi:ss:mmmAM (yoki PM)	Default + millisec
10	110	mm-dd-yyyy	USA
11	111	yyyy/mm/dd	Japan
12	112	yyyymmdd	ISO
13	113	dd mon yyyy hh:mi:ss:mmm	Europe (24 hour clock)>
14	114	hh:mi:ss:mmm	24 hour clock
20	120	yyyy-mm-dd hh:mi:ss	ODBC canonical (24 hour clock)
21	121	yyyy-mm-dd hh:mi:ss.mmm	ODBC canonical (24 hour clock)
	126	yyyy-mm-ddThh:mi:ss.mmm	ISO8601
	127	yyyy-mm-ddThh:mi:ss.mmmZ	ISO8601 (Z vaqt zonasi bilan)
	130	dd mon yyyy hh:mi:ss:mmmAM	Hijiri
	131	dd/mm/yy hh:mi:ss:mmmAM	Hijiri

Converting float to real:

Qiymat	Explanation
0	Maximum 6 digits (default)
1	8 digits
2	16 digits

Converting money to character:

Qiymat	Explanation
0	Vergul ajratgichsiz, o‘nli kasrning o‘ng tomonida 2 ta raqam
1	Vergul ajratgichlar, o‘nli kasrning o‘ng tomonida 2 ta raqam
2	Vergul ajratgichsiz, o‘nli kasrning o‘ng tomonida 4 ta raqam

Texnik tafsilotlar

Qo‘llab-quvvatlaydigan tizimlar:	SQL Server (2008 dan boshlab), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Ko‘proq misollar

Misol

Ifodani bir ma’lumot turidan boshqasiga o‘tkazish (varchar):

SELECT CONVERT(varchar, 25.65);

O‘zingiz sinab ko‘ring »

Misol

Ifodani bir ma’lumot turidan boshqasiga o‘tkazish (sana vaqti):

SELECT CONVERT(datetime, '2017-08-25');

O‘zingiz sinab ko‘ring »

Misol

Ifodani bir ma’lumot turidan boshqasiga o‘tkazish (varchar):

SELECT CONVERT(varchar, '2017-08-25', 101);

O‘zingiz sinab ko‘ring »

W3Schools Pathfinder

Yutuqlaringizni kuzating – bu bepul!

Ro'yxatdan o'tish Kirish