Free for PREMIUM members
, YEAR(getdate()) - YEAR(BirthDate)
- ( CASE
WHEN MONTH(BirthDate) > MONTH(getdate())
OR ( MONTH(BirthDate) = MONTH(getdate())
AND DAY(BirthDate) > DAY(getdate())
END ) AS AgeReg
Open in new window
MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.
DECLARE @d AS datetime = '2013-12-31'
, convert(varchar(10),brthdate,121) AS brthdate
, YEAR(@d) - YEAR(brthdate)
- ( CASE
WHEN MONTH(brthdate) > MONTH(@d)
OR ( MONTH(brthdate) = MONTH(@d)
AND DAY(brthdate) > DAY(@d)
END ) AS Age_by_case
, YEAR(@d) - YEAR(brthdate) AS "Age by year - year"
This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.