isms Publish time 19-12-2012 10:00 AM

How to convert INTEGER to varchar

salam,
sapa2 ada formula tok convert INT to varchar, boleh share tak. cth :
saya ada field kod_pejabat=101010 (int (4)) n sy nak convet ke data type varchar(4)
DB : SQL
Language : PHP




alam. Publish time 20-12-2012 02:44 PM

convert(varchar(4),kod_pejabat)...
--> select convert(varchar(4),kod_pejabat) FROM TableName

tp kenapa nk convert ke length(4)... sbb tgk sample data kod_pejabat tuh mcm 101010 = length(6)
adakh sebab nk amik 4 terawal?.. kalo nk amik 4 terawal just

--> select left(kodpejabat,4)

isms Publish time 20-12-2012 03:49 PM

alam. posted on 20-12-2012 02:44 PM static/image/common/back.gif
convert(varchar(4),kod_pejabat)...
--> select convert(varchar(4),kod_pejabat) FROM TableName



tq bro.
tp bila sy buat coding tuh kuar error gni "Fatal error:Call to undefined functionconvert()"

isms Publish time 20-12-2012 03:52 PM

alam. posted on 20-12-2012 02:44 PM static/image/common/back.gif
convert(varchar(4),kod_pejabat)...
--> select convert(varchar(4),kod_pejabat) FROM TableName



bab data tuh plak, sy pun x leh nak jawab, sbb sy tgk format db lama int(4), tp db baru lak varchar(4)
tp kalau tgk data yg nak transfer tuh samapai 8 digit pun ada

alam. Publish time 20-12-2012 04:21 PM

isms posted on 20-12-2012 03:52 PM static/image/common/back.gif
bab data tuh plak, sy pun x leh nak jawab, sbb sy tgk format db lama int(4), tp db baru lak varcha ...

ummmmmmmmmm mcm mana datatype int(4) tp data length sampai 8.. xpa lh forget it...
hah guna MS SQL or mySQL..

kalo mySQL
--> select cast(tableNAme.Kod_Pejabat as char(4)) from TableName




kambinggila Publish time 22-12-2012 12:58 AM

boleh post sql code tu kat sini tak?
Pages: [1]
View full version: How to convert INTEGER to varchar


ADVERTISEMENT