Convertion of char values into smalldatetime values.

• Atang

  Valued Member

  Points: 53

  More actions

  October 6, 2010 at 5:00 am

  #224726

  Convert(ServiceDate,SmallDateTime)

• Cadavre

  SSC-Forever

  Points: 41690

  More actions

  October 6, 2010 at 5:08 am

  #1232373

  atang.mogwera (10/6/2010)

  ---

  Convert(ServiceDate,SmallDateTime)

  Wrong way around.

  CONVERT(SmallDateTime,'2010-01-01')

  ---

  Forever trying to learn
  My blog - http://www.cadavre.co.uk/
  For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
  For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  ---