Tuesday 3 April 2018

How to Get Current/Today's date data in SQL Server.

How to Get Current/Today's date data in SQL Server

Description:


In this example we explain that how to get records of Today SQL Server. Or SQL Query to get the Data from table which recorded today. Or how to get today’s inserted record in SQL Server. Or basic SQL query to select records added today in SQL Server. Or get all record created today in SQL Server. Or how to get current date data in SQL Server. Or SQL query that returns records by date today.

So here we demonstrate that how to get current/Today's date data in SQL Server. Below is the SQL query that will retrieve all the records that are created today.
Query:

SELECT * FROM [dbo].[Order] WHERE  [Loading Date] =   dateadd(day,datediff(day,0,GETDATE()),0)


This entry was posted in :

0 comments:

Post a Comment