How to save a TimeStamp value

• charles-1011021

  Old Hand

  Points: 315

  More actions

  April 18, 2012 at 12:16 pm

  #150895

  I am trying to save a timestamp to a Binary(8) column and converting it to Binary(8), withno luck updating the table where I am tring to save it. This is an example of what I am trying

  UPDATE [TS].[dbo].[MPPS Data Vault]

  SET [LastBarcodeTimeStamp] = (SELECT CONVERT(varbinary(max), MAX(timestamp), 1) as TS From [TS].[dbo].[Barcodes])

  WHERE RowCounter = 1

  Any ideas?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 18, 2012 at 12:24 pm

  #1475581

  Duplicate post. Please post replies here.