10 Replies Latest reply: Sep 27, 2012 4:34 AM by Janzen Jino Balasbas RSS

    difference between date type values



      i have date-time data coming in from sql server in the form of integar

      ex:  one column 'abc' contains values such as :  1002171551 (date value in: yymmddhhmm)

      2nd column 'def' contains values such as : 100217 or 1002170000 (date value in: yymmdd)


      now i need to calculate difference between these two columns and i want sql server to treat these as date columns and not integar ones.

      right now when i do the difference i get result purely as in subtraction of 2 integar values. but i want the result to be calculated as a difference between dates.s


      any suggestions?