摘要:
--時區時間 Local Time Zone Geovin Du 塗聚文--http://www.bigresource.com/MS_SQL-Converting-UTC-datetime-values-to-local-time-zones-XDKMI9sG.htmlSELECT GETUTCDATE()SELECT GETDATE()select CONVERT(varchar(100), GETUTCDATE(), 21)SELECT DATEDIFF(hh,'2008-05-20 20:08:01.020', '2008-05-20 16:08:01.020& 阅读全文
posted @ 2012-05-11 11:35
®Geovin Du Dream Park™
阅读(841)评论(0)推荐(0)
编辑
摘要:
select EmployeesList.*,datediff(year,EmployeesList.EmployeeEnterDate,getdate()) as 'InJobTime' from EmployeesList---Geovin Du 塗聚文select EmployeesList.*,datediff(month,EmployeesList.EmployeeEnterDate,getdate()) as 'InJobTime' from EmployeesListselect EmployeesList.*,datediff(month,Emp 阅读全文
posted @ 2012-04-24 19:14
®Geovin Du Dream Park™
阅读(599)评论(0)推荐(0)
编辑