1、sqlserver
SELECT CONVERT
( VARCHAR, DATEDIFF( MONTH, asset_list.PURCHASE_DATE, getdate( ) ) ) + '个月' AS use_date,
DATEADD( MONTH, asset_list.service_life, asset_list.purchase_date ) AS end_date
FROM
asset_list
2、oracle、达梦
SELECT
ceil ( months_between ( sysdate, asset_list.purchase_date ) ) || '个月' AS use_date,
add_months ( asset_list.purchase_date, asset_list.service_life ) AS end_date
FROM
asset_list
3、mysql
SELECT
CONCAT( TIMESTAMPDIFF( MONTH, asset_list.PURCHASE_DATE, NOW()), '个月' ) AS use_date,
DATE_ADD( asset_list.purchase_date, INTERVAL asset_list.service_life MONTH ) AS end_date
FROM
asset_list