Equals Today's Date in SQL RRS feed

  • Question

  • I have a query in SQL that needs to check for Date Column(InsertDate) equals Today's date or not in the where Clause . When i use <= or >= it works fine .How do i check for Today's date in where Clause  ? Please guide me ,thanks in advance.

    Select EMPID,EmpDept,EmpName,EmpInsertDate
    from Employees 
    where EMPInsertDate = (Convert(varchar(10), GetDate(),110))


    Monday, October 28, 2013 7:10 PM


All replies