interview

Home / DeveloperSection / Interviews / What is the function to find the Current time and date in SQL Server?

Ask Question
Ashutosh Kumar Verma

Ashutosh Kumar Verma

Follow
Myself Ashutosh Kumar Verma from Varanasi. I am a Software Developer in MindStick Software pvt. ltd. Prayagraj. I have completed my MCA from VBSP. University, Jaunpur in 2021.

Can you answer this question?

Answer

1 Answers

Ashutosh Kumar Verma

Ashutosh Kumar Verma

19-Nov-2021

SQL CURRENT_TIMESTAMP:

SQL CURRENT_TIMESTAMP function is used to find the current time and date.

Example:

SELECT CURRENT_TIMESTAMP;

Output:

2021-11-19 21:34:48.493

Another function is GETDATE() is also used to find the current time and date.

SELECT GETDATE();

Output:

2021-11-19 21:38:48.547

Liked By