How can we help you today? How can we help you today?

Spaces inside brackets inside CONVERT.

I have spaces inside brackets OFF, but layout this: 
SELECT  CONVERT(varchar(8),DATEADD(d, 1, GETDATE()),112) AS Date
gives: 
SELECT  CONVERT( varchar(8), DATEADD(d, 1, GETDATE()), 112 ) AS Date
But have to be like this: 
SELECT  CONVERT(varchar(8), DATEADD(d, 1, GETDATE()), 112) AS Date
EloyOrion
0

Comments

1 comment

Sort by
  • Andras B
    EloyOrion wrote:
    I have spaces inside brackets OFF, but layout this: 
    SELECT  CONVERT(varchar(8),DATEADD(d, 1, GETDATE()),112) AS Date
    gives: 
    SELECT  CONVERT( varchar(8), DATEADD(d, 1, GETDATE()), 112 ) AS Date
    But have to be like this: 
    SELECT  CONVERT(varchar(8), DATEADD(d, 1, GETDATE()), 112) AS Date

    Thank you, this is indeed a bug, and we will aim to fix it for the final release.

    Regards,
    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.