datediff···不用了就忘 郁闷~! Code: select datediff(s,erpe_createddate,getdate()) from ERPEntityMappings --s 秒 --d 天