Text copied!
GETDATE function
Hi! You should check
CASE statement
post first.
In SQL, GETDATE function is used to return the current system date and time in default format of the SQL Server instance.
The syntax of the GETDATE function generally looks like this :
GETDATE( )
• It is a zero parameter function that means it doesn't accept any argument.
Here's an example of how you might use the GETDATE function :
1. Let's assume we have a table named "[Employees]".
2. Let's assume you want to append a new column called [CurrentDateTime] to the [Employees] table, containing the current date and time.
3. Run below SQL statement :
SELECT *, GETDATE() AS CurrentDateTime
FROM [Employees];
4. In above statement, GETDATE function retrieves the current date and time and display it as the result in a column named 'CurrentDateTime'.
Remember :
Using this function in a select statement won't modify the [Employees] table directly, but it will only be reflected in the select statement's output.
To enhance your understanding of 'SQL functions', be sure to check out our next tutorial.
Frequently Asked Questions :
Thank You! You should check
DATEPART function
post next.