select name,{fn TIMESTAMPDIFF(SQL_TSI_YEAR, {fn CURDATE()}, crdate)} from sysdatabases. This sql works on SQL Server 2016 and Azure SQL ...
確定! 回上一頁