---
title: "What is the difference between GETDATE and SYSDATETIME?"  
description: "What is the difference between GETDATE and SYSDATETIME?"  
author: "MindStick Software Pvt Ltd"  
published: 2019-09-19  
updated: 2020-09-20  
canonical: https://www.mindstick.com/interview/33628/what-is-the-difference-between-getdate-and-sysdatetime  
category: "mssql server"  
tags: ["sql server"]  
reading_time: 1 minute  

---

# What is the difference between GETDATE and SYSDATETIME?

As far as the GETDATE and SYSDATETIME are concerned, these two are almost identical but GETDATE can give up to milliseconds and SYSDATETIME can be accurate to nanoseconds. According to accuracy, the SYSDATETIME is more accurate than GETDATE.

## Answers

### Answer by MindStick Software Pvt Ltd

As far as the GETDATE and SYSDATETIME are concerned, these two are almost identical but GETDATE can give up to milliseconds and SYSDATETIME can be accurate to nanoseconds. According to accuracy, the SYSDATETIME is more accurate than GETDATE.


---

Original Source: https://www.mindstick.com/interview/33628/what-is-the-difference-between-getdate-and-sysdatetime

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