Sql today - 1

Problem

When working with SQL Server, you often need to get the current date without the time component. To achieve this in T-SQL, you can use several straightforward methods. Here, we will show you the most efficient and easiest way.

Solution

We’ll use the function to get the current date and time.

Then we’ll use the CAST() function to convert the returned datetime data type into a date data type.

SELECT CAST( GETDATE() AS Date ) ;

Here’s the result of the query:

2019-08-17

Discussion

To get the current date and time in SQL Server, use the function.

This function returns a datetime data type; in other words, it contains both the date and the time, e.g. . (Note: This function doesn’t take any arguments, so you don’t have to put anything in the brackets.)

However, if you want to get just the current date – not the date and the time – you can use the function.

Select * from table where date = today

This function takes any expression or any column name as the first argument. Then you use the keyword AS and enter the new data type to return. (The returned value(s) could be column values or the result returned

how to get today date data in sql query

how to get todays date in oracle sql developer