Hey, readers! In our previous article, we had understood the working of SQL Server DATEPART() function. In this article, we will be focusing on SQL Server GETDATE() function.
Working of SQL Server GETDATE() function
SQL GETDATE()
function is used to fetch the current date and time from the system.
The GETDATE() function renders the below format while representing the current timestamp i.e. the current date and time.
Having understood the working of SQL GETDATE() function, lets jump into understanding the syntax of the same.
Syntax of SQL Server GETDATE() function
Unlike other SQL Date functions, the GETDATE() function does not accept any parameter. It does return the current date and time in the below format — YYYY-MM-DD hh:mm:ss.mmm
.
Syntax:
GETDATE()
Now, let us understand the implementation of this function through various examples in the below section.
Examples of SQL Server GETDATE() function
In the below example, we have used SQL SELECT statement
along with GETDATE() function to display the current date and time.
Example 1:
select GETDATE();
Output:
2020-06-05T15:14:39.967Z
Example 2:
In this example, we have used SQL Server DATEPART() function
wherein we have passed the interval to be extracted as ‘month‘ from the input date as the current date obtained through GETDATE() function
as a parameter to the DATEDIFF() function.
SELECT DATEPART(month, GETDATE()) AS Output;
Output:
6
GETDATE() v/s CURRENT_TIMESTAMP()
While understanding the SQL Server Date Functions, we may come across the below question.
What’s the difference between GETDATE() function and CURRENT_TIMESTAMP() function, if both the functions return exactly the same value!?
Well, both functions have the same implementation. The only basic difference spotted is the origin of the functions i.e. CURRENT_TIMESTAMP() is an ANSI SQL function while GETDATE() is a T-SQL function.
Conclusion
By this, we have come to the end of this topic. Please feel free to comment below if you come across any doubts.
For more such posts on similar topics related to SQL Server, please do visit SQL Server JournalDev.