SQLéé¢æ个DATEADDçå½æ°ãæ¶é´æ³å°±æ¯ä¸ä¸ªä»1970-01-01 08:00:00å°æ¶é´çç¸éçç§æ°ã
注解ï¼å京æ¶é´ä¸GMTæ¶é´å
³ç³»
1ãGMTæ¯ä¸å¤®æ¶åº,å京å¨ä¸8åº,ç¸å·®8个å°æ¶ ãã
2ãæ以å京æ¶é´ = GMTæ¶é´ + å
«å°æ¶
ä¾å¦ï¼
SELECT DATEADD(S,1160701488 + 8 * 3600,'1970-01-01 00:00:00') --æ¶é´æ³è½¬æ¢ææ®éæ¶é´
SELECT DATEDIFF(S,'1970-01-01 00:00:00', '2006-10-13 09:04:48.000') - 8 * 3600 --æ®éæ¶é´è½¬æ¢ææ¶é´æ³
温馨提示:答案为网友推荐,仅供参考