Search code examples
sqlsql-servercurrent-time

how to get current/Todays date data in sql server

how to write query to get today's date data in SQL server ?

select * from tbl_name where date = <Todays_date>
Solution

  • The correct answer will depend on the type of your datecolumn. Assuming it is of type Date:

    select * from tbl_name 
where datecolumn = cast(getdate() as Date)

    If it is DateTime:

    select * from tbl_name 
where cast(datecolumn as Date) = cast(getdate() as Date)

    Please note: In SQL Server, a datediff() (or other calculation) on a column is NOT Sargable, whereas as CAST(column AS Date) is.