Concatenate date for JSON payload

• delizat4g

  Old Hand

  Points: 369

  More actions

  April 16, 2019 at 5:59 pm

  #3414986

  Afternoon,

  I'm working on encoding a json token and I'm getting this - "Conversion failed when converting date and/or time from character string"

  Ex:

  --2016 compatibility

  declare @data varbinary(max)

  declare @base64string varchar(max)

  select @data = convert(varbinary(max), '{"note":"ALL THESE WORLDS ARE YOURS...","iat":' + getdate() + ', "valid":"true"}');

  select @base64string = cast('' as xml).value('xs:base64Binary(sql:variable(''@data''))', 'varchar(max)')

  Any help,

  Thanks!

  • This topic was modified 5 years ago by  delizat4g. Reason: Not enough information

  Code-Blooded

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  April 16, 2019 at 8:21 pm

  #3416478

  You need to explicitly convert getdate(), for example:

  CONVERT(CHAR(8), GETDATE(), 112)

  --Vadim R.

• delizat4g

  Old Hand

  Points: 369

  More actions

  April 16, 2019 at 8:59 pm

  #3416814

  That worked perfect. Thanks for the reply!

  Code-Blooded