摘要:
1.C#的 datetime.ticks 转sql server的datetimedeclare @now bigintset @now = 634723487546704691select dateadd(s, (@now -621355968000000000)/(10000*1000 ), convert(datetime,'1970-01-01 00:00:00.000'))其中:621355968000000000= 1970-01-01 00:00:00.000返回:2012-05-11 15:59:14.000.NET 是从 0001-01-01 00:00:00 阅读全文