摘要：一.日期时间类型二.常用的日期时间相关函数①.获取时间精度较低的函数select GETDATE() as getdateselect GETUTCDATE() as getutcdate精度较高的函数select SYSDATETIME() as sysdatetimeselect SYSDATETIMEOFFSET() as sysdatetimeoffset --包含时区select SYSUTCDATETIME() as sysutcdatetime②.获取时间部分datepart(datepart,date),返回date的datepart部分的整数year(date),返回date 阅读全文

摘要：为说明其差别，建立一张数据表，插入几条数据create table tblStudent(id nvarchar(10) primary key,name nvarchar(21)not null,)insert into tblStudent(id,name) values('2008110101','张三');insert into tblStudent(id,name) values('2008110102','李四');insert into tblStudent(id,name) values('20081101 阅读全文