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:
|
1 |
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
|
1 |
SELECT GETDATE() AS [Current_Date] |
OUTPUT
SQL GETDATE Function Example 2
In this example, we are going show you the SQL Server GETDATE examples.
SQL CODE
|
1 2 3 4 5 6 7 |
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
ANALYSIS
We used the SQL DATEPART function to display the year value from today’s date
|
1 |
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
|
1 |
SELECT 'Month' AS 'MONTH', DATENAME(month, GETDATE()) AS [Month_Name]; |
We used the SQL DATEADD function to display the Tomorrow date
|
1 |
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
|
1 2 3 4 5 6 7 8 9 |
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
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
Leave a Reply