第十二节 时间函数

Date & TTimee fuuncttionnsCurTiime()Daay()DayyOfWWeekk()DDayOOfYeear()Hoour()LoocallTimme()Minnutee()MMontth()Seccondds()TimmeDaay()TimmeDaayOffWeeek()TimmeDaayOffYeaar()TimmeHoour()TiimeMMinuute()TiimeMMontth()TimmeSeeconnds()TiimeYYearr()YYearr()datetime CurTime()Returrns lasst kknowwn sservver''s ttimee, nnumbber of seccondds eelappsedd frrom 00:00JJanuuaryy 1, 19970.Samplle if(CurrTimme() - OrdderOOpennTimme()<3660) retturnn(0);int Day()Returrns currrennt ddatee's dayy off moonthh.Samplle if(Dayy()<<5) retturnn(0);int DayOfWeek()Returrns currrennt ddatee's zerro bbaseed dday of weeek (0-SSundday,1,22,3,4,55,6).Samplle / do nott woork on hollidaays.if(DaayOffWeeek()=00 | DaayOffWeeek()=66) rretuurn(0);int DayOfYear()Returrns currrennt ddatee's dayy off yeear (1-1 jjanuuaryy,.,3665(66) - 311 deecemmberr).Samplle if(DayyOfYYearr() = 2455) rretuurn(truue);int Hour()Returrns currrennt hhourr (00,1,2,.233)Samplle boool iis_ssiessta=fallse; if(Houur() >= 122 | Hoour()<117) is_sieestaa=trrue;datetime LocalTime()Returrns loccal commputter timme, nummberr off seeconnds elaapseed ffromm 000:000Jannuarry 11, 119700.Samplle if(SerrverrTimme() - OrdderOOpennTimme()<3660) retturnn(0);int Minute()Returrns currrennt mminuute (0,1,22,.59).Samplle if(Minnutee()<<=155) rretuurn("fiirstt quuartter"");int Month()Returrns currrennt mmontth aas nnumbber (1-Jannuarry,22,3,4,55,6,7,88,9,10,11,12).Samplle if(Monnth()<=5) rretuurn("fiirstt haalf of yeaar");int Seconds()Returrns currrennt ssecoond (0,1,22,.59).Samplle if(Seccondds()<=115) rretuurn(0);int TimeDay(datetime date)Returrns dayy off moonthh (11 - 31) foor sspeccifiied datte.Parammeteersdate  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt daay = TiimeDDay(D'220033.122.311');/ daay iis 331int TimeDayOfWeek(datetime date)Returrns zerro bbaseed dday of weeek (0-SSundday,1,22,3,4,55,6) foor sspeccifiied datte.Parammeteersdate  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt weeekdday = TTimeeDayyOfWWeekk(D''20004.111.22');/ daay iis 11 - tueesdaayint TimeDayOfYear(void date)Returrns dayy (11-1 jannuarry,.,3365(6) - 331 ddeceembeer) of yeaar ffor speeciffiedd daate.Parammeteersdate  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt daay = TiimeDDayOOfYeear(CurrTimme();int TimeHour(datetime time)Returrns houur ffor speeciffiedd tiime.Parammeteerstime  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt h = TTimeeHouur(CCurTTimee();int TimeMinute(datetime time)Returrns minnutee foor sspeccifiied timme.Parammeteerstime  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt m = TTimeeMinnutee(CuurTiime();int TimeMonth(datetime time)Returrns monnth forr sppeciifieed ttimee.Parammeteerstime  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt m = TTimeeMonnth(CurrTimme();int TimeSeconds(datetime time)Returrns seccondds ffor speeciffiedd tiime.Parammeteerstime  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt m = TTimeeSeccondds(CCurTTimee();int TimeYear(datetime time)Returrns yeaar ffor speeciffiedd daate. Reeturrn vvaluues cann bee inn raangee 19970-20337.Parammeteerstime  -  Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Samplle intt y = TTimeeYeaar(CCurTTimee();int Year()Returrns currrennt yyearr.Samplle / retturnn iff daate befforee 1 Mayy 20002if(Yeear()=20002 &&& MMontth()<5) rretuurn(0);日期时间函函数 Datte && Tiime Funnctiionssdatettimee CuurTiime( )返返回当前前时间示示例:if(CuurTiime()-OOrdeerOppenTTimee()<<3600) rretuurn(0);int DDay()返回回当前日日期示例例:if(Daay()<5) reeturrn(00);int DDayOOfWeeek( )返返回当前前日期是是星期几几 0-星期天天,1,2,33,4,5,66示例:/ doo noot wworkk onn hooliddayss.iff(DaayOffWeeek()=00 | DaayOffWeeek()=66) rretuurn(0);int DDayOOfYeear( )返返回当前前日期在在年内的的第几天天示例:if(DaayOffYeaar()=2245)retturnn(trrue);int HHourr()返返回当前前的小时时数 00-233示例:bool is_sieestaa=faalsee;iff(Hoour()>=12 | Houur()<177)iss_siiestta=ttruee;datettimee LoocallTimme()返回当当前电脑脑时间示示例:if(LoocallTimme()-OrrderrOpeenTiime()<3360) reeturrn(00);int MMinuute()返回回当前分分钟示例例:if(Miinutte()<=115)rretuurn("fiirstt quuartter"");int MMontth()返回当当前月份份示例:if(Moonthh()<<=5)retturnn("ffirsst hhalff off yeear"");int SSecoondss()返返回当前前秒数示示例:if(Seeconnds()<=15)retturnn(0);int TTimeeDayy( ddateetimme ddatee)返回回输入日日期中的的日期: 输入入参数ddatee - 输入日日期示例:int dday=TimmeDaay(DD'20003.12.31'');/ dday is 31int TTimeeDayyOfWWeekk( ddateetimme ddatee)返回回输入日日期中的的日期是是星期几几 (00-6) : 输入入参数ddatee - 输入日日期示例:int wweekkdayy=TiimeDDayOOfWeeek(D'220044.111.2'');/ dday is 2 - tuuesddayint TTimeeDayyOfYYearr( ddateetimme ddatee)返回回输入日日期中的的日期在在当年中中的第几几天: 输入入参数ddatee - 输入日日期示例:int dday=TimmeDaayOffYeaar(CCurTTimee();int TTimeeHouur( dattetiime timme)返返回输入入日期中中的小时时: 输入入参数ddatee - 输入日日期示例:int hh=TiimeHHourr(CuurTiime();int TTimeeMinnutee( ddateetimme ttimee)返回回输入日日期中的的分钟: 输入入参数ddatee - 输入日日期示例:int mm=TiimeMMinuute(CurrTimme();int TTimeeMonnth( daatettimee tiime)返回输输入日期期中的月月份: 输入入参数ddatee - 输入日日期示例:int mm=TiimeMMontth(CCurTTimee();int TTimeeSeccondds( dattetiime timme)返返回输入入日期中中的秒钟钟: 输入入参数ddatee - 输入日日期示例:int mm=TiimeSSecoondss(CuurTiime();int TTimeeYeaar( dattetiime timme)返返回输入入日期中中的年份份: 输入入参数ddatee - 输入日日期示例:int yy=TiimeYYearr(CuurTiime();int TTimeeYeaar( dattetiime timme)返返回当前前年份示示例:/ reeturrn iif ddatee beeforre 11 Maay 220022if(Yeaar()=220022 &&& Moonthh()<<5)rretuurn(0);