---
title: "What is the function to find the Current time and date in SQL Server?"  
description: "What is the function to find the Current time and date in SQL Server?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-19  
canonical: https://www.mindstick.com/interview/33838/what-is-the-function-to-find-the-current-time-and-date-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# What is the function to find the Current time and date in SQL Server?

## 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
```

## Answers

### Answer by Ashutosh Kumar Verma

## 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
```


---

Original Source: https://www.mindstick.com/interview/33838/what-is-the-function-to-find-the-current-time-and-date-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.