DateTime Problem

• RazorbackDBA

  SSC Eights!

  Points: 897

  More actions

  June 9, 2014 at 11:32 pm

  #308979

  Hello All,

  I am running into a problem trying to subtract my datetime cloumn from current datetime as follows:

  select column1, getdate() - column2 as newcolumn2

  from table1

  I get a result of '1900-01-01 hh:mm:ss.sss' I am looking for days, hours.

  Thanks all

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  June 10, 2014 at 12:54 am

  #1720281

  Try using the DATEDIFF function instead.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• RazorbackDBA

  SSC Eights!

  Points: 897

  More actions

  June 10, 2014 at 3:44 am

  #1720314

  Thanks, that helped.