SQL Date Selections

dates.sql

/** Get date and time stamp for today/now: **/
SELECT GETDATE()

/** Get today's date: **/
SELECT CONVERT(date, GETDATE())
               
/** Select records with today's date **/
/** Example below using an Esri versioned view **/
SELECT [OBJECTID]
      ,[DYETESTNUMBER]
      ,[SCHEDULEDDATE]
      ,[SCHEDULEDTIME]
      ,[TESTSTARTTIME]
      ,[Shape]
  FROM [DyeTest].[dbo].DyeTest_evw
  WHERE SCHEDULEDDATE LIKE CONCAT(CONVERT(date, GETDATE()), '%')