Converting Getdate to smalldate

• gjuarez

  Old Hand

  Points: 395

  More actions

  August 31, 2016 at 3:14 pm

  #329761

  i am querying a date field, it is a smalldate, not null field. The date format in this field is below, i have tried different converts, cast to get date converted to this format but nothing is working. What i tried returns the date but in the time returns the actual time, the field i am querying the time for all records is zeros.

  date format in field

  210-08-03 00:00:00

  What i tried

  SELECT CONVERT(datetime, CONVERT(varchar, GETDATE(), 110))

  SELECT CAST(GETDATE() AS SMALLDATETIME)

• drew.allen

  SSC Guru

  Points: 77012

  More actions

  August 31, 2016 at 3:45 pm

  #1898664

  There are several ways that you can accomplish this. Probably the most straightforward is the following.

  SELECT CAST(CAST(GETDATE() AS DATE) AS SMALLDATETIME)

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA