Did you install SQL Server 2012 Standard Edition for evaluation purposes on your PC and forgot to write down when your six months is up? Yep, you’re right, I’m talking from experience here! So I needed some T-SQL magic to help me and here it is for you:
create_date AS 'Install Date',
DATEADD(DD, 180, create_date) AS 'Expiry Date'
name = 'NT AUTHORITY\SYSTEM'
It’s nice and simple we simply find the install and 180 days (6 months) onto it using DATEADD(). That should stop the pain when a pop up tells the evaluation period has ended.