Date Format

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  March 23, 2016 at 11:31 pm

  #305852

  HI

  I am using date add Query for following method

  update OfflineExamScheduleMaster

  set edatetime=dateadd(mi,50,getdate()),

  I got the result for example...

  2016-03-24 11:52:16.207

  But i want following format

  2016-03-24 11:52:00.000

  I want Milli secong and nano second should be zero..

  Please help me Query

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  March 23, 2016 at 11:54 pm

  #1867320

  set edatetime=dateadd(mi,datediff(mi, 0, getdate()) + 50, 0)

  _____________
  Code for TallyGenerator

• Eirikur Eiriksson

  SSC Guru

  Points: 182912

  More actions

  March 23, 2016 at 11:56 pm

  #1867321

  vs.satheesh (3/23/2016)

  ---

  HI

  I am using date add Query for following method

  update OfflineExamScheduleMaster

  set edatetime=dateadd(mi,50,getdate()),

  I got the result for example...

  2016-03-24 11:52:16.207

  But i want following format

  2016-03-24 11:52:00.000

  I want Milli secong and nano second should be zero..

  Please help me Query

  You can use double type conversion, first to smalldatetime and then back to datetime

  😎

  SELECT CONVERT(DATETIME,CONVERT(SMALLDATETIME,DATEADD(MINUTE,50,GETDATE()),0),0) AS edatetime