Best way to convert & compare 2 dates

• gregarobinson

  Right there with Babe

  Points: 736

  More actions

  November 11, 2008 at 12:46 pm

  #195936

  I do a BULK Insert reading a CSV file. One of the values in this CSV file stores a date, "20080919"

  In a WHERE clause I need to compare this CSV value to a smalldatetime field in a SQL Server 2005 table. The value in the table will look like this: "2008-09-19 00:00:00".

  I know I need to convert one or both, what's the best approach?

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 11, 2008 at 12:58 pm

  #897127

  At least in my install SQL Server will implicit convert '20080919' to a date like in this query:

  Select

  Case

  When '20080919' > getdate() then 1

  Else 2

  End

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question