Date extracting

• johnwhbrownlee

  Newbie

  Points: 9

  More actions

  May 27, 2003 at 8:10 am

  #80947

  I would like to return an datetime field as Date and the Hour segment with the Minute segment always set to '00' ?

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 27, 2003 at 8:44 am

  #458663

  select cast((convert(varchar(4), DATEPART( yy , getdate())) + '-' +

  convert(varchar(2), DATEPART(mm , getdate())) + '-' +

  convert(varchar(2), DATEPART(dd , getdate())) + ' ' +

  convert(varchar(2), DATEPART(hh , getdate())) + ':' + '00:00') as datetime)

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  May 27, 2003 at 8:54 am

  #458669

  Here is another alternative:

  select cast((convert(char(13),getdate(),120) + ':00:00.000') as datetime)

  Gregory Larsen, DBA

  If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP