---
title: "Retrieve SQL Server Installation Date Time"  
description: "Question: How do I retrieve SQL  Server Installation date?  Answer: Run the following query  and it will give you the date of SQL Server Installation."  
author: "AVADHESH PATEL"  
published: 2012-11-01  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/386/retrieve-sql-server-installation-date-time  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Retrieve SQL Server Installation Date Time

**[Question](https://www.mindstick.com/blog/23175/how-to-solve-neet-question-paper-in-less-time):** How do I [retrieve](https://www.mindstick.com/forum/34400/how-to-retrieve-form-values-in-controller-action) SQL [Server Installation](https://www.mindstick.com/articles/710/apache-server-installation-on-windows) date?\

**Answer:** Run the following [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver) and it will give you the date of [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) Installation.

```
SELECT create_dateFROM sys.server_principalsWHERE sid =
0x010100000000000512000000
```

Question: I have installed SQL Server [Evaluation](https://yourviews.mindstick.com/view/81125/time-for-evaluation-of-traditions) [version](https://www.mindstick.com/articles/12845/things-to-remember-while-migrating-odoo-to-a-better-version). How do I know what is the expiry date for it?

Answer: SQL Server evaluation [period](https://yourviews.mindstick.com/story/2247/some-great-indian-dynasties-before-mughal-period) lasts for 180 days. The expiration date is always 180 days from the initial installation. The following query will give the expiration date of evaluation version:

```
-- Evaluation Version Expire DateSELECT create_date AS InstallationDate,DATEADD(DD, 180,
create_date) AS
'Expiry Date'FROM sys.server_principalsWHERE sid =
0x010100000000000512000000GO
```

---

Original Source: https://www.mindstick.com/blog/386/retrieve-sql-server-installation-date-time

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