Conversion failed when converting date and/or time from character string, but works with hard coded value?

Question

Conversion failed when converting date and/or time from character string, but works with hard coded value?

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply

curtin.schafer SSC Rookie Points: 37 More actions · Answer 1

I just finished wrestling with CounterData.CounterDateTime. I am seeing it as a CHAR(24) with the 24th character showing as ASCII code 0. CAST(LEFT(CounterDateTime ,23) AS DATETIME) seems to be working for me. Aargh!