datetime datatype

• sql_prodigy

  SSCrazy

  Points: 2254

  More actions

  May 28, 2009 at 3:21 am

  #134471

  hi guys, can any help with the below sql

  select getdate()

  returns 2009-05-28 11:18:49.123 as datetime datatype

  is there a way i can format the getdate()

  to return as 2009-05-28 00:00:00.000 datetime datatype

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 28, 2009 at 3:23 am

  #1001275

  SELECT DATEADD (DAY, DATEDIFF (DAY, 0, '2009-05-28 11:18:49.123'), 0)

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• sql_prodigy

  SSCrazy

  Points: 2254

  More actions

  May 28, 2009 at 3:30 am

  #1001278

  many thanks

• dhulme

  Mr or Mrs. 500

  Points: 570

  More actions

  May 28, 2009 at 9:15 am

  #1001493

  Frank Kalis (5/28/2009)

  ---

  SELECT DATEADD (DAY, DATEDIFF (DAY, 0, '2009-05-28 11:18:49.123'), 0)

  Might be a little more usful if it returned tomorrow's date if it is run tomorrow:

  SELECT DATEADD (DAY, DATEDIFF (DAY, 0, getdate()), 0)