Cannot convert valid Char(24) date/time to date/time data type

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  September 3, 2013 at 4:18 pm

  #1647161

  Dennis Post (9/3/2013)

  ---

  I haven't been able to REPLACE the CHAR(0) nor have I been able to detect it with:

  Force a binary collation:

  replace(col COLLATE Latin1_General_BIN2, char(0), ' ')

  An non-binary SQL collation as suggested by Sean works too, but only with varchar.

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

• fouzan 240

  Valued Member

  Points: 51

  More actions

  March 3, 2014 at 6:09 pm

  #1693739

  Hi All,

  Check this it will work:

  select * from CounterData

  where

  CONVERT(datetime,CONVERT(char(23),CounterDateTime),121)>dateadd(mi,-60,getdate())

  Thanks,

  Fouzan

• Dennis Post

  SSCarpal Tunnel

  Points: 4473

  More actions

  March 4, 2014 at 6:05 am

  #1693850

  Thanks. Was already resolved, but you code also works.

  ---

  
  For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

  "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort