---
title: "How to find the Current Database UTC date and time in SQL Server?"  
description: "How to find the Current Database UTC date and time in SQL Server?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-23  
updated: 2023-06-20  
canonical: https://www.mindstick.com/interview/33846/how-to-find-the-current-database-utc-date-and-time-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# How to find the Current Database UTC date and time in SQL Server?

## GETUTCDATE():

SQL GETUTCDATE() function is returns the current Database UTC (Coordinated Universal Time) date and time SQL Server.

## Example:

```
    SELECT GETUTCDATE();
```

```
Output:  2021-11-24 05:09:12.570
```

## Answers

### Answer by Aryan Kumar

There are two functions that you can use to find the current database UTC date and time in SQL Server:

- GETUTCDATE()
- SYSUTCDATE()

The GETUTCDATE() function returns the current database system UTC date and time, in a 'YYYY-MM-DD hh:mm:ss. mmm' format.

The SYSUTCDATE() function also returns the current database system UTC date and time, but it has more fractional seconds precision.

For example, the following query will return the current database UTC date and time:

SQL

```plaintext
SELECT GETUTCDATE();
```

This query will return a value in the format 'YYYY-MM-DD hh:mm:ss. mmm'.

Here is the syntax for the GETUTCDATE() function:

SQL

```plaintext
GETUTCDATE ( )
```

Here is the syntax for the SYSUTCDATE() function:

SQL

```plaintext
SYSUTCDATE ( )
```

Both of these functions are very efficient, and they will not block other queries from running.

### Answer by Ashutosh Kumar Verma

## GETUTCDATE():

SQL GETUTCDATE() function is returns the current Database UTC (Coordinated Universal Time) date and time SQL Server.

## Example:

```
    SELECT GETUTCDATE();
```

```
Output:  2021-11-24 05:09:12.570
```


---

Original Source: https://www.mindstick.com/interview/33846/how-to-find-the-current-database-utc-date-and-time-in-sql-server

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