如题所述
datediff("d",data1,date2)
è¯æ³ DATEDIFF ( date-part, date1, date2 )
date-part : year | quarter | month | week | day | hour | minute | second | millisecond
åæ° date-part æå®è¦æµéå ¶é´éçæ¥æé¨åã
æå ³æ¥æé¨åç详ç»ä¿¡æ¯ï¼è¯·åè§æ¥æé¨åã
date1 æä¸é´éçèµ·å§æ¥æãä» date-expression-2 ä¸åå»è¯¥å¼ï¼è¿å两个åæ°ä¹é´ date-parts ç天æ°ã
date2 æä¸é´éçç»ææ¥æãä»è¯¥å¼ä¸åå» Date-expression-1ï¼è¿å两个åæ°ä¹é´ date-parts ç天æ°ã
ç¨æ³ æ¤å½æ°è®¡ç®ä¸¤ä¸ªæå®æ¥æä¹é´æ¥æé¨åçæ°ç®ãç»æ为æ¥æé¨åä¸çäºï¼date2 - date1ï¼çæ符å·çæ´æ°å¼ã
å½ç»æä¸æ¯æ¥æé¨åçå¶æ°åæ¶ï¼DATEDIFF å°è¢«æªæèä¸æ¯è¢«èå ¥ã
å½ä½¿ç¨ day ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æå®çæ¶é´ä¹é´ï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼çåå¤æ°ã
å½ä½¿ç¨ month ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æ¥æä¹é´ï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼åºç°çæç第ä¸å¤©çæ°ç®ã
å½ä½¿ç¨ week ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æ¥æï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼ä¹é´æææ¥çæ°ç®ã
è¯æ³ DATEDIFF ( date-part, date1, date2 )
date-part : year | quarter | month | week | day | hour | minute | second | millisecond
åæ° date-part æå®è¦æµéå ¶é´éçæ¥æé¨åã
æå ³æ¥æé¨åç详ç»ä¿¡æ¯ï¼è¯·åè§æ¥æé¨åã
date1 æä¸é´éçèµ·å§æ¥æãä» date-expression-2 ä¸åå»è¯¥å¼ï¼è¿å两个åæ°ä¹é´ date-parts ç天æ°ã
date2 æä¸é´éçç»ææ¥æãä»è¯¥å¼ä¸åå» Date-expression-1ï¼è¿å两个åæ°ä¹é´ date-parts ç天æ°ã
ç¨æ³ æ¤å½æ°è®¡ç®ä¸¤ä¸ªæå®æ¥æä¹é´æ¥æé¨åçæ°ç®ãç»æ为æ¥æé¨åä¸çäºï¼date2 - date1ï¼çæ符å·çæ´æ°å¼ã
å½ç»æä¸æ¯æ¥æé¨åçå¶æ°åæ¶ï¼DATEDIFF å°è¢«æªæèä¸æ¯è¢«èå ¥ã
å½ä½¿ç¨ day ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æå®çæ¶é´ä¹é´ï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼çåå¤æ°ã
å½ä½¿ç¨ month ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æ¥æä¹é´ï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼åºç°çæç第ä¸å¤©çæ°ç®ã
å½ä½¿ç¨ week ä½ä¸ºæ¥æé¨åæ¶ï¼DATEDIFF è¿å两个æ¥æï¼å æ¬ç¬¬äºä¸ªæ¥æä½ä¸å æ¬ç¬¬ä¸ä¸ªæ¥æï¼ä¹é´æææ¥çæ°ç®ã
温馨提示:答案为网友推荐,仅供参考