SQL Server: problem with string concatenation
I'm trying this as part of a big query:
(CONVERT(varchar(20), AZ_DTA_APP_AGE, 103) + ' ' + (CONVERT(varchar(20), AZ_DTA_APP_AGE, 108)) AS AZ_DTA_APP_AGE
W开发者_Python百科hy it doesn't work?
I get:
Syntax error near keyword 'AS'
The 1st convert is missing a ')'
(CONVERT(varchar(20), AZ_DTA_APP_AGE, 103)) + ' ' + (CONVERT(varchar(20), AZ_DTA_APP_AGE, 108)) AS AZ_DTA_APP_AGE`
精彩评论