摘要:
SQL如下:select 年=year(getdate()),月=month(getdate()),日=day(getdate()) ,小时=datepart(hour,getdate()) ,分钟=datepart(minute,getdate()) ,秒=datepart(second,getdate())将系统的时间拼接成年月日,小时分钟秒。select CAST(YEAR(getDate()) AS varchar(10)) + '年' + CAST(MONTH(getDate()) AS varchar(10)) + '月' + CAST(DAY(ge 阅读全文