摘要:
执行SELECT datediff(ss,'2011-05-27','2085-1-1')报错两个 datetime 列的差别导致了运行时溢出因为 两个时间取 秒的 时间差 间隔 太大了。datepart缩写yearyy, yyyyquarterqq, qmonthmm, mdayofyeardy, ydaydd, dweekwk, wwweekdaydw, whourhhminutemi, nsecondss, smillisecondmsmicrosecondmcsnanosecondns 阅读全文