how to get current/Todays date data in sql server

sql sql-server current-time
krishna mohan picture krishna mohan · Mar 5, 2015 · Viewed 83.7k times · Source

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

select * from tbl_name where date = <Todays_date>

Answer

Mitch Wheat picture Mitch Wheat · Mar 5, 2015

The correct answer will depend of the exact 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)

Related questions

Comparing results with today's date?

Is there a way to use the Now() function in SQL to select values with today's date? I was under the impression Now() would contain the time as well as date, but today's date would have the time set to 00:00:00 …

Read More
Getting the current date in SQL Server?

How can I get the current date in MS-SQL Server 2008 R2? The format of the column in my database is DATETIME and dates are stored in the following format: +++++++++++++ Vrdate ++++++++++ | | | 2012-11-18 00:00:00.000 | | 2012-11-19 00:00:00.000 | | 2013-11-18 00:00:00.000 | | 2012-12-01 00:00:00.000 | | 2010-10-09 00:00:00.000 | | 2012…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More