You are looking the date and time when was the last service package was applied into the Microsoft SQL Server. There are 2 ways for you to achieve this.
Method 1
Go to the following directory of the setup bootstrap, depending on your installed SQL Server version and open the Summary text file.
C:\Program Files\Microsoft SQL Server\[sql-version]\Setup Bootstrap\Log
You will get the start/end date and time here.
Overall summary:
Final result: Passed
Exit code (Decimal): 0
Start time: 2020-05-28 23:07:23
End time: 2020-05-28 23:11:53
Requested action: Install
Machine Properties:
Machine name: ITSITI
Machine processor count: 8
OS version: Future Windows Version
OS service pack:
OS region: United States
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Product features discovered:
Product Instance Instance ID Feature Language Edition Version Clustered Configured
Package properties:
Description: Microsoft SQL Server 2012
ProductName: SQL Server 2012
Type: RTM
Version: 11
Installation location: F:\MEDIA\EnterpriseEdition\x64\setup\
Installation edition: Enterprise Edition: Core-based Licensing
Slipstream: True
SP Level 4
Product Update Status:
Success: KB 4018073
Product Updates Selected for Installation:
Title: Service Pack 4
Knowledge Based Article: KB 4018073
Version: 11.4.7001.0
Architecture: x64
Language: 1033
Update Source: F:\MEDIA\51047515\SP4\X64
Method 2
Open the “Installed Updates” from the Windows search function. From here, search for Service Pack under Microsoft SQL Server. You will get the date from the “Installed On” information.
