SELECT CAST(DATENAME(YEAR, DATEADD(mi, 30, GETDATE())) + '-' + DATENAME(MONTH, DATEADD(mi, 30, GETDATE()))
+ '-' + DATENAME(DAY, DATEADD(mi, 30, GETDATE())) + ' ' + DATENAME(HOUR, DATEADD(mi, 30, GETDATE())) + ':00:00' AS DATETIME)
SELECT DATENAME(YEAR, DATEADD(mi, 30, GETDATE()))
SELECT DATENAME(MONTH, DATEADD(mi, 30, GETDATE()))
SELECT DATENAME(DAY, DATEADD(mi, 30, GETDATE()))
SELECT DATENAME(HOUR, DATEADD(mi, 30, GETDATE()))