Tutorial Gateway

SQL GETDATE Function

by

SQL GETDATE function is one of the Date and Time Function, which is used to return the Current Date and Time. The return value of this function is derived from the OS (operating System) of the computer on which the SQL Server instance is running.

SQL GETDATE Syntax

The basic syntax of the GETDATE Statement in SQL Server is as follows:

GETDATE()

We can use this function to find out:

  • When was the data inserted, or updated?
  • Maintaining the Log files
  • When was the last order, customer has made?
  • How long an Employee associated with us? etc

SQL GETDATE Function Example 1

The SQL Server GETDATE function returns datetime data type, and the format is: ‘yyyy-mm-dd hh:mm:ss.mmm’ (you can see, fractional seconds precision is 3).

SQL CODE

SELECT GETDATE() AS [Current_Date]

OUTPUT

SQL GETDATE Function 1

SQL GETDATE Function Example 2

In this example, we are going show you the SQL Server GETDATE examples.

SQL CODE

SELECT 'Today' AS 'TODAY', GETDATE() AS [Current_Date];

SELECT 'Year' AS 'YEAR', DATEPART(year, GETDATE()) AS [Present_Year]; 

SELECT 'Month' AS 'MONTH', DATENAME(month, GETDATE()) AS [Month_Name]; 

SELECT 'Tomorrow' AS 'DAY', DATEADD(day, 1, GETDATE()) AS [Next_Day];

OUTPUT

SQL GETDATE Function 2

ANALYSIS

We used the SQL DATEPART function to display the year value from today’s date

SELECT 'Year' AS 'YEAR', DATEPART(year, GETDATE()) AS [Present_Year];

We used the SQL DATENAME function to display the Month name from today’s date

SELECT 'Month' AS 'MONTH', DATENAME(month, GETDATE()) AS [Month_Name];

We used the SQL DATEADD function to display the Tomorrow date

SELECT 'Tomorrow' AS 'DAY', DATEADD(day, 1, GETDATE()) AS [Next_Day];

SQL GETDATE Function Example 3

In this example, we are going to check Employee details (such as: What date we hired him, how long he associated with this company etc). For this we are using SQL DATEDIFF function.

SQL CODE

SELECT [FirstName] + ' '+ [LastName] AS [Full Name]
      ,[Occupation]
      ,[YearlyIncome]
      ,[HireDate]
      ,DATEDIFF (year, [HireDate], GETDATE()) AS [YEARS]
      ,DATEDIFF (quarter, [HireDate], GETDATE()) AS [QUARTERS]
      ,DATEDIFF (month, [HireDate], GETDATE()) AS [MONTHS]
      ,DATEDIFF (day, [HireDate], GETDATE()) AS [DAYS]
  FROM [SQL Tutorial].[dbo].[Employee]

OUTPUT

SQL GETDATE Function 3

From the above screenshot you can observe that, we used the DATEDIFF function to find the difference between the Employee Hire date and Today (GETDTE()). I suggest you to refer SQL DATEDIFF function article to understand the above code.

Thank You for Visiting Our Blog

Placed Under: SQL