Conversion of datetime

• anithagovindarajalu

  SSC Eights!

  Points: 981

  More actions

  November 3, 2009 at 6:28 am

  #206223

  Hi,

  I need to convert the time from datetime value to milliseconds.

  For Example if we schedule the job with date is '2009-11-03 10:19:13.5000000' , then sysjobschedules stores the startdate and starttime in which the starttime holds the milliseconds value i.e converting hours,minutes into milliseconds.

  Can anyone help me out the logic behind this calculation?

  Thanks

  Anitha

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  November 3, 2009 at 8:06 am

  #1074283

  You'd need to get the datepart for seconds, or strip out the value.

  The calculation is then seconds * 1000 for ms.

  multiply by 60 for minutes to ms.