Get the version, edition, and expiry data if evaluation for SQL Server

sql-server-edition-version.sql

select
	SERVERPROPERTY('ProductVersion') AS ProductVersion,
	SERVERPROPERTY('ProductLevel') AS ProductLevel,
	SERVERPROPERTY('Edition') AS Edition,
	create_date AS 'SQLServerInstallDate',
	case
		when CAST(SERVERPROPERTY('Edition') as nvarchar(100)) like '% evaluation %' then
			DATEADD(day, 180, create_date) --evaluation periods for 180 days
		else
			''
	end as 'SQLServerEvaluationEpireDate'
from
	sys.server_principals
where
	name = 'NT AUTHORITY\SYSTEM' --this account created at install time