How to determine the academic year of an Aeries database in SQL.
To get the full YYYY-YYYY string you can use the following.
Modified on: Tue, Mar 21, 2017 at 11:07 AM
How to determine the academic year of an Aeries database in SQL.
SELECT CAST(20-FLOOR(CAST(SUBSTRING(DB_NAME(),4,2) AS INT)/80) AS VARCHAR(2)) + CAST(SUBSTRING(DB_NAME(),4,2) AS VARCHAR(2))
To get the full YYYY-YYYY string you can use the following.
DECLARE @Y1 as int = CAST(20-FLOOR(CAST(SUBSTRING(DB_NAME(),4,2) AS INT)/80) AS VARCHAR(2)) + CAST(SUBSTRING(DB_NAME(),4,2) AS VARCHAR(2))
SELECT CAST(@Y1 AS VARCHAR(4)) + '-' + CAST(@Y1 +1 AS VARCHAR(4))
Did you find it helpful? Yes No
Send feedback