开发者

SQL Server: problem with string concatenation

开发者 https://www.devze.com 2023-01-03 21:37 出处:网络
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

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`
0

精彩评论

暂无评论...
验证码 换一张
取 消