ÊÖ»úÕ¾
ÍøÍ¨·ÖÕ¾
µçÐÅÖ÷Õ¾
ÃÜ¡¡Âë:
Óû§Ãû£º
µ±Ç°Î»Öà : Ö÷Ò³>ÍøÂç±à³Ì>Asp±à³Ì>Áбí

ASPÖÐʱ¼äº¯ÊýµÄʹÓÃ(Èý)

À´Ô´£º»¥ÁªÍø ×÷Õߣºwest263.com ʱ¼ä£º2008-02-23
Î÷²¿ÊýÂë-È«¹úÐéÄâÖ÷»ú10Ç¿£¡40ÓàÏîÐéÄâÖ÷»ú¹ÜÀí¹¦ÄÜ,È«¹úÁìÏÈ!Ë«Ïß¶àÏßÐéÄâÖ÷»úÄϱ±·ÃÎʳ©Í¨ÎÞ×è!Ãâ·ÑÔùËÍÆóÒµÓʾÖ,.CNÓòÃû,×ÔÖú½¨Õ¾480ÔªÆð,Ãâ·ÑÊÔÓÃ7Ìì,ÂúÒâÔÙ¸¶¿î! P4Ö÷»ú×âÓÃ799Ôª/ÔÂ.Ô¸¶Ãâѹ½ð!
MonthName º¯Êý
ÃèÊö:·µ»Ø±íÃ÷Ö¸¶¨Ô·ݵÄ×Ö·û´®¡£
Óï·¨:MonthName(month[, abbreviate])
month: ±ØÑ¡¡£Ô·ݵÄÊýÖµ¶¨Òå¡£ÀýÈ磬һÔÂÊÇ 1£¬¶þÔÂÊÇ 2£¬ÒÔ´ËÀàÍÆ¡£
abbreviate: ¿ÉÑ¡¡£Boolean Öµ£¬±íÃ÷Ô·ÝÃû³ÆÊÇ·ñ¼òд¡£Èç¹ûÊ¡ÂÔ£¬Ä¬ÈÏֵΪ False£¬¼´²»¼òдÔ·ÝÃû³Æ¡£

Now º¯Êý
ÃèÊö:¸ù¾Ý¼ÆËã»úϵͳÉ趨µÄÈÕÆÚºÍʱ¼ä·µ»Øµ±Ç°µÄÈÕÆÚºÍʱ¼äÖµ¡£
Óï·¨:Now

Second º¯Êý
ÃèÊö:·µ»Ø 0 µ½ 59 Ö®¼äµÄÒ»¸öÕûÊý£¨°üÀ¨ 1 ºÍ 59£©£¬´ú±íÒ»·ÖÖÓÄÚµÄijһÃë¡£
Óï·¨:Second(time)
time ²ÎÊýÊÇÈÎÒâ¿ÉÒÔ´ú±íʱ¼äµÄ±í´ïʽ¡£Èç¹û time ²ÎÊýÖаüº¬ Null£¬Ôò·µ»Ø Null¡£

Time º¯Êý
ÃèÊö:·µ»Ø Date ×ÓÀàÐÍ Variant£¬Ö¸Ê¾µ±Ç°ÏµÍ³Ê±¼ä¡£
Óï·¨:Time

TimeSerial º¯Êý
ÃèÊö:·µ»ØÒ»¸ö Date ×ÓÀàÐ굀 Variant£¬º¬ÓÐÖ¸¶¨Ê±¡¢·Ö¡¢ÃëµÄʱ¼ä¡£
Óï·¨:TimeSerial(hour, minute, second)
hour: ÆäֵΪ´Ó 0 (12:00 A.M.) µ½ 23 (11:00 P.M.) µÄÊýÖµ»òÊýÖµ±í´ïʽ¡£
minute: ÈÎÒâÊýÖµ±í´ïʽ¡£
second: ÈÎÒâÊýÖµ±í´ïʽ¡£
˵Ã÷:ÒªÖ¸¶¨Ò»Ê±¿Ì£¬Èç 11:59:59£¬TimeSerial µÄ²ÎÊýȡֵӦÔڿɽÓÊܵķ¶Î§ÄÚ£»Ò²¾ÍÊÇ˵£¬Ð¡Ê±Ó¦½éÓÚ 0-23 Ö®¼ä£¬·ÖºÍÃëÓ¦½éÓÚ 0-59 Ö®¼ä¡£µ«ÊÇ£¬¿ÉÒÔʹÓÃÊýÖµ±í´ïʽΪÿ¸ö²ÎÊýÖ¸¶¨Ïà¶Ôʱ¼ä£¬ÕâÒ»±í´ïʽ´ú±íijʱ¿Ì֮ǰ»òÖ®ºóµÄʱ¡¢·Ö»òÃëÊý¡£ÒÔÏÂÑùÀýÖÐʹÓÃÁ˱í´ïʽ´úÌæ¾ø¶Ôʱ¼äÊý¡£TimeSerial º¯Êý·µ»ØÖÐÎç֮ǰÁùСʱ (12 - 6) Ê®Îå·ÖÖÓµÄʱ¼ä (-15)£¬¼´ 5:45:00 A.M.¡£
TimeSerial(12 - 6, -15, 0)
µ±ÈκÎÒ»¸ö²ÎÊýµÄȡֵ³¬³ö¿É½ÓÊܵķ¶Î§Ê±£¬Ëü»áÕýÈ·µØ½øÎ»µ½ÏÂÒ»¸ö½Ï´óµÄʱ¼äµ¥Î»ÖС£ÀýÈ磬Èç¹ûÖ¸¶¨ÁË 75 ·ÖÖÓ£¬ÔòÕâ¸öʱ¼ä±»½âÊͳÉһСʱʮÎå·ÖÖÓ¡£µ«ÊÇ£¬Èç¹ûÈκÎÒ»¸ö²ÎÊýÖµ³¬³ö -32768 µ½ 32767 µÄ·¶Î§£¬¾Í»áµ¼Ö´íÎó¡£Èç¹ûʹÓÃÈý¸ö²ÎÊýÖ±½ÓÖ¸¶¨µÄʱ¼ä»òͨ¹ý±í´ïʽ¼ÆËã³öµÄʱ¼ä³¬³ö¿É½ÓÊܵÄÈÕÆÚ·¶Î§£¬Ò²»áµ¼Ö´íÎó¡£

TimeValue º¯Êý
ÃèÊö:·µ»Ø°üº¬Ê±¼äµÄ Date ×ÓÀàÐ굀 Variant¡£
Óï·¨:TimeValue(time)
time ²ÎÊýͨ³£ÊÇ´ú±í´Ó 0:00:00 (12:00:00 A.M.) µ½ 23:59:59 (11:59:59 P.M.) µÄ×Ö·û´®±í´ïʽ£¨°üÀ¨ 0:00:00 ºÍ 23:59:59£©¡£²»¹ý£¬time Ò²¿ÉÒÔÊÇ´ú±í¸Ã·¶Î§ÄÚÈκÎʱ¼äµÄ±í´ïʽ¡£Èç¹û time ²ÎÊý°üº¬ Null£¬Ôò·µ»Ø Null¡£
˵Ã÷:¿ÉÒÔ²ÉÓà 12 »ò 24 СʱʱÖÓ¸ñʽÊäÈëʱ¼ä¡£ÀýÈç "2:24PM" ºÍ "14:24" ¶¼ÊÇÓÐЧµÄ time ²ÎÊý¡£
Èç¹û time ²ÎÊý°üº¬ÈÕÆÚÐÅÏ¢£¬ TimeValue º¯Êý²¢²»·µ»ØÈÕÆÚÐÅÏ¢¡£È»¶ø£¬Èç¹û time ²ÎÊý°üº¬ÎÞЧµÄÈÕÆÚÐÅÏ¢£¬Ôò»á³öÏÖ´íÎó¡£

Weekday º¯Êý
ÃèÊö:·µ»Ø´ú±íÒ»ÐÇÆÚÖÐijÌìµÄÕûÊý¡£
Óï·¨:Weekday(date, [firstdayofweek])
date: ¿ÉÒÔ´ú±íÈÕÆÚµÄÈÎÒâ±í´ïʽ¡£Èç¹û date ²ÎÊýÖаüº¬ Null£¬Ôò·µ»Ø Null¡£
firstdayofweek: Ö¸¶¨ÐÇÆÚÖеÚÒ»ÌìµÄ³£Êý¡£Èç¹ûÊ¡ÂÔ£¬Ä¬ÈÏʹÓà vbSunday¡£
firstdayofweek ²ÎÊýÓÐÈçÏÂÉèÖãº
(ÒÔÏ·ֱðΪ£º³£Êý Öµ ÃèÊö)
vbUseSystem 0 ʹÓÃÇøÓòÓïÑÔÖ§³Ö (NLS) API ÉèÖá£
vbSunday 1 ÐÇÆÚÈÕ
vbMonday 2 ÐÇÆÚÒ»
vbTuesday 3 ÐÇÆÚ¶þ
vbWednesday 4 ÐÇÆÚÈý
vbThursday 5 ÐÇÆÚËÄ
vbFriday 6 ÐÇÆÚÎå
vbSaturday 7 ÐÇÆÚÁù
Weekday º¯Êý·µ»ØÈçÏÂÖµ£º
(ÒÔÏ·ֱðΪ£º³£Êý Öµ ÃèÊö)
vbSunday 1 ÐÇÆÚÈÕ
vbMonday 2 ÐÇÆÚÒ»
vbTuesday 3 ÐÇÆÚ¶þ
vbWednesday 4 ÐÇÆÚÈý
vbThursday 5 ÐÇÆÚËÄ
vbFriday 6 ÐÇÆÚÎå
vbSaturday 7 ÐÇÆÚÁù

WeekdayName º¯Êý
ÃèÊö:·µ»ØÒ»¸ö×Ö·û´®£¬±íʾÐÇÆÚÖÐÖ¸¶¨µÄijһÌì¡£
Óï·¨:WeekDayName(weekday, abbreviate, firstdayofweek)
weekday: ±ØÑ¡¡£ÐÇÆÚÖÐijÌìµÄÊýÖµ¶¨Òå¡£¸÷ÌìµÄÊýÖµ¶¨ÒåÈ¡¾öÓÚ firstdayofweek ²ÎÊýÉèÖá£
abbreviate: ¿ÉÑ¡¡£Boolean Öµ£¬Ö¸Ã÷ÊÇ·ñËõд±íʾÐÇÆÚ¸÷ÌìµÄÃû³Æ¡£Èç¹ûÊ¡ÂÔ£¬ ĬÈÏֵΪ False£¬¼´²»ËõдÐÇÆÚ¸÷ÌìµÄÃû³Æ¡£
firstdayofweek: ¿ÉÑ¡¡£Ö¸Ã÷ÐÇÆÚµÚÒ»ÌìµÄÊýÖµ¡£¹ØÓÚÊýÖµ£¬Çë²ÎÔÄ¡°ÉèÖá±²¿·Ö¡£
firstdayofweek ²ÎÊýÓÐÒÔÏÂÖµ£º
(ÒÔÏ·ֱðΪ£º³£Êý Öµ ÃèÊö)
vbUseSystem 0 ʹÓÃÇøÓòÓïÑÔÖ§³Ö (NLS) API ÉèÖá£
vbSunday 1 ÐÇÆÚÈÕ£¨Ä¬ÈÏ£©
vbMonday 2 ÐÇÆÚÒ»
vbTuesday 3 ÐÇÆÚ¶þ
vbWednesday 4 ÐÇÆÚÈý
vbThursday 5 ÐÇÆÚËÄ
vbFriday 6 ÐÇÆÚÎå
vbSaturday 7 ÐÇÆÚÁù

Year º¯Êý
ÃèÊö:·µ»ØÒ»¸ö´ú±íijÄêµÄÕûÊý¡£
Óï·¨:Year(date)
date ²ÎÊýÊÇÈÎÒâ¿ÉÒÔ´ú±íÈÕÆÚµÄ²ÎÊý¡£Èç¹û date ²ÎÊýÖаüº¬ Null£¬Ôò·µ»Ø Null¡£

ÎÄÕÂÕûÀí£ºÎ÷²¿ÊýÂë--רҵÌṩÓòÃû×¢²á¡¢ÐéÄâÖ÷»ú·þÎñ
http://www.west263.com
ÒÔÉÏÐÅÏ¢ÓëÎÄÕÂÕýÎÄÊDz»¿É·Ö¸îµÄÒ»²¿·Ö,Èç¹ûÄúÒª×ªÔØ±¾ÎÄÕÂ,Çë±£ÁôÒÔÉÏÐÅÏ¢£¬Ð»Ð»!