Minnu (12/5/2012)
Hi Team,Am using below code to display name and "Date of birth"
but Field DOB is not coming in Date format.
select @FinalString=(SELECT RTRIM(+ISNULL('Name ','')+' : ' +ISNULL(+CAST(NAME AS VARCHAR(100))+' ','') +ISNULL(' DOB :'+CAST(DOB AS VARCHAR(100))+' ',''))
FROM ETCOL i want date format in below format.
rtrim(convert(varchar, DOB,107)) + ')'
Can u please help me .....
If you want it formated like rtrim(convert(varchar, DOB,107)) then use it in the select statement?
select @FinalString=(SELECT RTRIM(+ISNULL('Name ','')+' : ' +
ISNULL(+CAST(NAME AS VARCHAR(100))+' ','') +
ISNULL(' DOB :'+rtrim(convert(varchar(10), DOB,107)) +' ','')) FROM ETCOL
I prefer to be explicit with my CONVERT(VARCHAR(12), DOB,107), since you are going to get a 30 character varchar variable by default, instead of the 12 character that you need.