摘要:
一.日期时间类型二.常用的日期时间相关函数①.获取时间精度较低的函数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 阅读全文
posted @ 2012-06-20 12:54 softwaror 阅读(379) 评论(0) 推荐(0) 编辑