TSQL Filtering by a Date

"the real stevenkjames"

Here is a snippet of TSQL code that looks at a database and returns just by date and ordered by date.

By a Specific Date…

  SELECT  *
  FROM [DatabaseName].[Schema].[TableName]
  where Cast(LogDate as date) = '2019-06-19'
  order by LogDate desc

By Todays Date…

  SELECT  *
  FROM [DatabaseName].[Schema].[TableName]
  where Cast(LogDate as date) = Cast(GetDate() as date)
  order by LogDate desc

Leave a comment