How to select Today records from Sql Server

  SELECT CONVERT(DATE, DATE_CREATED) as DATE_CREATED,* FROM RESOURCES WHERE    DATE_CREATED=CONVERT (DATE, GETDATE())

 

  SELECT * FROM RESOURCES WHERE DATE_CREATED=CONVERT (DATE, GETDATE())