PPÍæÓÎÏ·ºÐ,Å·Å·ÓÎÏ·ºÐ×Ó
³É¶¼ÍøÕ¾½¨Éè
|
ÓòÃû×¢²á
|
ÐéÄâÖ÷»ú
|
ÍøÕ¾ÖÆ×÷
|
ÍøÕ¾°¸Àý
|
ÍøÕ¾ÓÅ»¯
|
ÍøÕ¾ÍÆ¹ã
|
ÆóÒµÓʾÖ
|
·þÎñÆ÷×âÓÃ
|¹ã¸æÉè¼Æ
Ê×Ò³
·þÎñÆ÷×âÓÃ
ÆóÒµÓÊÏä
ÐéÄâÖ÷»ú
ÍøÕ¾³ÌÐò
ÓªÏúÍÆ¹ã
ÍøÕ¾½¨Éè
ÓòÃû×¢²á
ǰ¶Ë¿ª·¢
ÍøÕ¾±¸°¸
ÍøÕ¾²ß»® | ÍøÕ¾½¨Éè | ÍøÕ¾°¸Àý | ÐéÄâÖ÷»ú | ÍøÕ¾ÍÆ¹ã | ÔÆ·þÎñÆ÷ | ³É¶¼ÍøÕ¾ÖÆ×÷¹«Ë¾ | php¿Õ¼ä | ¶ÀÁ¢IP¿Õ¼ä | jspÐéÄâÖ÷»ú
ÍøÕ¾³ÌÐò
java½Ì³Ì
asp³ÌÐò
asp.net³ÌÐò
vb±à³Ì
php³ÌÐò
C#³ÌÐò
·þÎñÆ÷×âÓÃ
web·þÎñÆ÷
FTP·þÎñÆ÷
·þÎñÆ÷ÍйÜ
·þÎñÆ÷×âÓÃ
vpsÖ÷»ú·þÎñÆ÷
ÆóÒµÓÊÏä
ÆóÒµÓÊÏäÓÅÊÆ
ÆóÒµÓÊÏäÉèÖÃ
ÓÊÏäÊÕ·¢ÎÊÌâ
ÓÊÏ书Äܽ²½â
ÓÊÏäÆäËûÎÊÌâ
ÐéÄâÖ÷»ú
Ö÷»ú¹ºÂò
Êý¾Ý¿â
Ö÷»ú¹ÜÀí
FTPÉÏ´«
Ö÷»úÐø·ÑÉý¼¶
ÓªÏúÍÆ¹ã
seoÓÅ»¯
ÍøÕ¾ÍÆ¹ã
ËÑË÷ÒýÇæ
Ãâ·Ñ×ÊÔ´
ÍøÕ¾½¨Éè
ÍøÕ¾·½°¸
ÍøÕ¾¸Ä°æ
ÍøÒ³Éè¼Æ
ÍøÕ¾Î¬»¤
ÍøÕ¾²ß»®
ÓòÃû×¢²á
ÓòÃûתÈë\ת³ö
Ó¢ÎÄÓòÃû
ͨÓÃÍøÖ·
ÖÐÎÄÓòÃû
ÓòÃû½âÎö
ǰ¶Ë¿ª·¢
html
jQuery
JavaScript½Ì³Ì
css
div+css
ÍøÕ¾±¸°¸
±¸°¸Á÷³ÌÖ¸ÄÏ
±¸°¸×ÊÁÏÏÂÔØ
±¸°¸³£¼ûÎÊÌâ
¸÷Ê¡±¸°¸ÒªÇó
ÒÆ¶¯»¥ÁªÍø
wapÊÖ»úÍøÕ¾
appÓ¦Óÿª·¢
Î¢ÍøÕ¾
µ±Ç°Î»Öãº
´´Ð»¥Áª
>>
³£¼ûÎÊÌâ
>>
ÍøÕ¾³ÌÐò
>>
asp³ÌÐò
>>
ASPÈÕÆÚ¸ñʽÊý¾Ý¼Ó¼õ¼ÆËã·½·¨
PPÍæÓÎÏ·ºÐ,Å·Å·ÓÎÏ·ºÐ×Ó:ASPÈÕÆÚ¸ñʽÊý¾Ý¼Ó¼õ¼ÆËã·½·¨
×÷Õߣº´´Ð»¥Áª ÎÄÕÂÀ´Ô´£ºÍøÕ¾³ÌÐò²¿ µã»÷Êý£º
¸üÐÂʱ¼ä£º2012-01-08
¡¡¡¡½ñÌìС±à»á¸ú´ó¼Ò˵µ½ASPÈÕÆÚ¸ñʽÊý¾Ý¼Ó¼õ¼ÆËã·½·¨£¬²¢²»ËãÂé·³£¬ÒòΪÔÚASPÖÐÒѾΪÎÒÃÇÌṩÁËרÃŵÄÈÕÆÚ¼Ó¼õº¯Êý¡£
1.ÈÕÆÚÏà¼Ó
DateAdd º¯Êý
¡¡¡¡·µ»ØÒÑÌí¼ÓÖ¸¶¨Ê±¼ä¼ä¸ôµÄÈÕÆÚ¡£
¡¡¡¡DateAdd(interval, number, date)
DateAdd º¯ÊýµÄÓï·¨ÓÐÒÔϲÎÊý
¡¡¡¡£¨1£©interval ±ØÑ¡Ïî¡£×Ö·û´®±í´ïʽ£¬±íʾҪÌí¼ÓµÄʱ¼ä¼ä¸ô¡£ÓйØÊýÖµ£¬Çë²ÎÔÄ¡°ÉèÖá±²¿·Ö¡£
¡¡¡¡£¨2£©number ±ØÑ¡Ïî¡£ÊýÖµ±í´ïʽ£¬±íʾҪÌí¼ÓµÄʱ¼ä¼ä¸ôµÄ¸öÊý¡£ÊýÖµ±í´ïʽ¿ÉÒÔÊÇÕýÊý£¨µÃµ½Î´À´µÄÈÕÆÚ£©»ò¸ºÊý£¨µÃµ½¹ýÈ¥µÄÈÕÆÚ£©¡£
¡¡¡¡£¨3£©date ±ØÑ¡Ïî¡£Variant »òÒªÌí¼Ó interval µÄ±íʾÈÕÆÚµÄÎÄ×Ö¡£
˵Ã÷
¡¡¡¡¿ÉÓà DateAdd º¯Êý´ÓÈÕÆÚÖÐÌí¼Ó»ò¼õÈ¥Ö¸¶¨Ê±¼ä¼ä¸ô¡£ÀýÈç¿ÉÒÔʹÓà DateAdd ´Óµ±ÌìËãÆð 30 ÌìÒÔºóµÄÈÕÆÚ»ò´ÓÏÖÔÚËãÆð 45 ·ÖÖÓ ÒÔºóµÄʱ¼ä¡£ÒªÏò date Ìí¼ÓÒÔ¡°ÈÕ¡±Îªµ¥Î»µÄʱ¼ä¼ä¸ô£¬¿ÉÒÔʹÓá°Ò»ÄêµÄÈÕÊý¡±£¨¡°y¡±£©¡¢¡°ÈÕ¡±£¨¡°d¡±£©»ò¡°Ò»ÖܵÄÈÕÊý¡±£¨¡°w¡±£©¡£
¡¡¡¡DateAdd º¯Êý²»»á·µ»ØÎÞЧÈÕÆÚ¡£ÈçÏÂʾÀý½« 95 Äê 1 Ô 31 ÈÕ¼ÓÉÏÒ»¸öÔ£º
¡¡¡¡NewDate = DateAdd("m", 1, "31-Jan-95")
¡¡¡¡ÔÚÕâ¸öʾÀýÖУ¬DateAdd ·µ»Ø 95 Äê 2 Ô 28 ÈÕ£¬¶ø²»ÊÇ 95 Äê 2 Ô 31 ÈÕ¡£Èç¹û date Ϊ 96 Äê 1 Ô 31 ÈÕ£¬Ôò·µ»Ø 96 Äê 2 Ô 29 ÈÕ£¬ÕâÊÇÒòΪ 1996 ÊÇÈòÄê¡£
¡¡¡¡Èç¹û¼ÆËãµÄÈÕÆÚÊÇÔÚ¹«Ôª 100 Äê֮ǰ£¬Ôò»á²úÉú´íÎó¡£
¡¡¡¡Èç¹û number ²»ÊÇ Long ÐÍÖµ£¬ÔòÔÚ¼ÆËãǰËÄÉáÎåÈëΪ×î½Ó½üµÄÕûÊý¡£
£².ÈÕÆÚÏà¼õ
DateDiff º¯Êý
¡¡¡¡·µ»ØÁ½¸öÈÕÆÚÖ®¼äµÄʱ¼ä¼ä¸ô¡£
¡¡¡¡DateDiff(interval, date1, date2 [,firstdayofweek[, firstweekofyear]])
DateDiff º¯ÊýµÄÓï·¨ÓÐÒÔϲÎÊý£º
¡¡¡¡£¨1£©interval ±ØÑ¡Ïî¡£×Ö·û´®±í´ïʽ£¬±íʾÓÃÓÚ¼ÆËã date1 ºÍ date2 Ö®¼äµÄʱ¼ä¼ä¸ô¡£ÓйØÊýÖµ£¬Çë²ÎÔÄ¡°ÉèÖá±²¿·Ö¡£
¡¡¡¡£¨2£©date1, date2 ±ØÑ¡Ïî¡£ÈÕÆÚ±í´ïʽ¡£ÓÃÓÚ¼ÆËãµÄÁ½¸öÈÕÆÚ¡£
¡¡¡¡£¨3£©Firstdayofweek ¿ÉÑ¡Ïî¡£Ö¸¶¨ÐÇÆÚÖеÚÒ»ÌìµÄ³£Êý¡£Èç¹ûûÓÐÖ¸¶¨£¬ÔòĬÈÏΪÐÇÆÚÈÕ¡£ÓйØÊýÖµ£¬Çë²ÎÔÄ¡°ÉèÖá±²¿·Ö¡£
¡¡¡¡£¨4£©Firstweekofyear ¿ÉÑ¡Ïî¡£Ö¸¶¨Ò»ÄêÖеÚÒ»Öܵij£Êý¡£Èç¹ûûÓÐÖ¸¶¨£¬ÔòĬÈÏΪ 1 Ô 1 ÈÕËùÔÚµÄÐÇÆÚ¡£ÓйØÊýÖµ£¬Çë²ÎÔÄ¡°ÉèÖá±²¿·Ö¡£
˵Ã÷
¡¡¡¡DateDiff º¯ÊýÓÃÓÚÅжÏÔÚÁ½¸öÈÕÆÚÖ®¼ä´æÔÚµÄÖ¸¶¨Ê±¼ä¼ä¸ôµÄÊýÄ¿¡£ÀýÈç¿ÉÒÔʹÓà DateDiff ¼ÆËãÁ½¸öÈÕÆÚÏà²îµÄÌìÊý£¬»òÕßµ±Ììµ½µ±Äê×îºóÒ»ÌìÖ®¼äµÄÐÇÆÚÊý¡£
¡¡¡¡Òª¼ÆËã date1 ºÍ date2 Ïà²îµÄÌìÊý£¬¿ÉÒÔʹÓá°Ò»ÄêµÄÈÕÊý¡±£¨¡°y¡±£©»ò¡°ÈÕ¡±£¨¡°d¡±£©¡£µ± interval Ϊ¡°Ò»ÖܵÄÈÕÊý¡± £¨¡°w¡±£©Ê±£¬DateDiff ·µ»ØÁ½¸öÈÕÆÚÖ®¼äµÄÐÇÆÚÊý¡£Èç¹û date1 ÊÇÐÇÆÚÒ»£¬Ôò DateDiff ¼ÆËãµ½ date2 ֮ǰÐÇÆÚÒ»µÄÊý Ä¿¡£´Ë½á¹û°üº¬ date2 ¶ø²»°üº¬ date1¡£Èç¹û interval ÊÇ¡°ÖÜ¡±£¨¡°ww¡±£©£¬Ôò DateDiff º¯Êý·µ»ØÈÕÀú±íÖÐÁ½¸öÈÕÆÚÖ® ¼äµÄÐÇÆÚÊý¡£º¯Êý¼ÆËã date1 ºÍ date2 Ö®¼äÐÇÆÚÈÕµÄÊýÄ¿¡£Èç¹û date2 ÊÇÐÇÆÚÈÕ£¬DateDiff ½«¼ÆËã date2£¬µ«¼´ ʹ date1 ÊÇÐÇÆÚÈÕ£¬Ò²²»»á¼ÆËã date1¡£
¡¡¡¡Èç¹û date1 ÍíÓÚ date2£¬Ôò DateDiff º¯Êý·µ»Ø¸ºÊý¡£
¡¡¡¡firstdayofweek ²ÎÊý»á¶ÔʹÓá°w¡±ºÍ¡°ww¡±¼ä¸ô·ûºÅµÄ¼ÆËã²úÉúÓ°Ïì¡£
¡¡¡¡Èç¹û date1 »ò date2 ÊÇÈÕÆÚÎÄ×Ö£¬ÔòÖ¸¶¨µÄÄê¶È»á³ÉΪÈÕÆÚµÄ¹Ì¶¨²¿·Ö¡£µ«ÊÇÈç¹û date1 »ò date2 ±»°üÀ¨ÔÚÒý ºÅ (" ") Öв¢ÇÒÊ¡ÂÔÄê·Ý£¬ÔòÔÚ´úÂëÖÐÿ´Î¼ÆËã date1 »ò date2 ±í´ïʽʱ£¬½«²åÈ뵱ǰÄê·Ý¡£ÕâÑù¾Í¿ÉÒÔ±àдÊÊÓÃÓÚ²»Í¬Äê·ÝµÄ³ÌÐò´ú Âë¡£
¡¡¡¡ÔÚ interval Ϊ¡°Äꡱ£¨¡°yyyy¡±£©Ê±£¬±È½Ï 12 Ô 31 ÈÕºÍÀ´ÄêµÄ 1 Ô 1 ÈÕ£¬ËäȻʵ¼ÊÉÏÖ»Ïà²îÒ»Ì죬DateDiff ·µ»Ø 1 ±íʾÏà²îÒ»¸öÄê·Ý¡£
Asp½«Ð¡Ð´Êý×ÖתΪ´óдÊý×Ö
:ÉÏһƪ
aspÈçºÎµ÷ÓÃ×Ó³ÌÐò½Ì³Ì
:ÏÂһƪ
PPÍæÓÎÏ·ºÐ,Å·Å·ÓÎÏ·ºÐ×Ó:
asp³ÌÐòÏà¹ØÎÄÕÂ
Asp½«Ð¡Ð´Êý×ÖתΪ´óдÊý×Ö
ASPµÄÓï·¨ºÍ±äÁ¿
Asp+AJAX·ÖÒ³
ASP³£ÓÃÔ´´úÂë×ܽá
ASPÖÐʵÏÖ·ÖÒ³ÏÔʾµÄÆßÖÖÎäÆ÷
asp²úÉúÒ»¸öËæ»úÊýRandom...
ASPÖÐÒ»¸ö±íµ¥¶à¸ö°´Å¥µÄʵÏÖ·½...
ΪʲôASPÓïÑÔ¿ª·¢µÄÍøÕ¾¸üÈÝÒ×...
×¨×¢ÍøÕ¾½¨Éè¡¢ÍøÒ³Éè¼Æ¡¢ÍøÕ¾ÖÆ×÷¡¢ÆóÒµÍøÕ¾½¨É衪¡ª´´Ð»¥Áª
PPÍæÓÎÏ·ºÐ,Å·Å·ÓÎÏ·ºÐ×Ó:
ÒÆ¶¯»¥ÁªÍø
|
ÍøÕ¾±¸°¸
|
ǰ¶Ë¿ª·¢
|
ÓòÃû×¢²á
|
ÍøÕ¾½¨Éè
|
ÓªÏúÍÆ¹ã
|
ÍøÕ¾³ÌÐò
|
ÐéÄâÖ÷»ú
|
ÆóÒµÓÊÏä
|
·þÎñÆ÷×âÓÃ
|
ÈÈÃÅËÑË÷
·þÎñµç»°£º028-86922220 13518219792 ¹«Ë¾µØÖ·£º³É¶¼ÊÐÌ«ÉýÄÏ·288ºÅ½õÌì¹ú¼ÊA´±10Â¥2ºÅ
ÆóÒµÓÊÏ䣺
service@cdxwcx.com
°æÈ¨ËùÓУº³É¶¼´´Ð»¥Áª¿Æ¼¼ÓÐÏÞ¹«Ë¾ ÊñICP±¸09010846ºÅ
³É¶¼ÍøÕ¾½¨Éè
PPÍæÓÎÏ·ºÐÔÚÏ߯½Ì¨Èë¿Ú£¨2026ÒѸüУ©¹Ù·½ÍøÕ¾¡¤IOS/°²×¿Í¨Óðæ/ÊÖ»úAPPÏÂÔØÆ¬×Ðñ¥Ò©Òµ¹É·ÝÓÐÏÞ¹«Ë¾