-- 一. sql server查询某个字段添加时间
SELECT
    c.name AS ColumnName,
    t.name AS TableName,
    o.create_date AS AddDate
FROM
    sys.columns c
JOIN
    sys.objects o ON c.object_id = o.object_id
JOIN
    sys.types t ON c.system_type_id = t.system_type_id
WHERE
    c.name = 'TTFC'
    AND o.type = 'U' -- U表示用户表
	AND o.name = '表名字'
--     AND o.name = '表名字'


-- 二.sql server查看整张表变动的最后时间
    1.查询表的对象 ID
    SELECT object_id,* FROM sys.tables WHERE name = '表名字' 
    2.使用对象 ID 查询表的索引信息
    SELECT last_user_update FROM sys.dm_db_index_usage_stats WHERE object_id = '692249571' AND database_id = DB_ID('库名字')

-- 三、运行时间
Date end = new Date();
Interval interval = new Interval(star.getTime(), end.getTime());
Period period = interval.toPeriod();
System.out.println(vo.getUserInfoDTO().getHospitalName() + ":" + vo.getOutMedPatDTO().getPatName() + "--->>保存用:" + period.getSeconds() + "." + period.getMillis() + "秒");