Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

GETDATE() Function in SQL Server

  • Last Updated : 18 Jan, 2021

GETDATE() function :
This function in SQL Server is used to return the present date and time of the database system in a ‘YYYY-MM-DD hh:mm:ss.mmm’ pattern.

Features :

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

  • This function is used to find the present date and time of the database system.
  • This function comes under Date Functions.
  • This function doesn’t accept any parameter.
  • This function returns output in ‘YYYY-MM-DD hh:mm:ss.mmm‘ format.

Syntax :

GETDATE()

Parameter :
This method doesn’t accept any parameter.



Returns :
It returns the present date and time of the database system in a ‘YYYY-MM-DD hh:mm:ss.mmm‘ format.

Example-1 :
Using GETDATE() function and getting the output.

SELECT GETDATE();

Output :

2021-01-03 14:42:58.970

Here, the output will vary each time the code is compiled as this method returns the current date and time.

Example-2 :
Using GETDATE() as a default value in the below example and getting the output.

CREATE TABLE get_date
(
id_num INT IDENTITY, 
message VARCHAR(150) NOT NULL, 
generated_at DATETIME NOT NULL
DEFAULT GETDATE(), 
PRIMARY KEY(id_num)
);

Inserting Data :

INSERT INTO get_date(message)
VALUES('Its the first message.');

INSERT INTO get_date(message)
VALUES('get_date');

Read Data :

SELECT id_num, message, generated_at
FROM get_date;

Output :

Index No.id_nummessagegenerated_at
11Its the first message. 03.01.2021 15:49:48
22get_date03.01.2021 15:49:48

Here, firstly you need to create a table then insert values into it then generate the required output using GETDATE() function as a default value.

Note –
For running the above code use SQL server compiler, you can also use an online compiler.

Application :
This function is used to return the current date and time of the database system.

My Personal Notes arrow_drop_up
Recommended Articles
Page :