第十二节 时间函数

上传人:夏** 文档编号:564061555 上传时间:2024-02-19 格式:DOCX 页数:8 大小:13KB
返回 下载 相关 举报
第十二节 时间函数_第1页
第1页 / 共8页
第十二节 时间函数_第2页
第2页 / 共8页
第十二节 时间函数_第3页
第3页 / 共8页
第十二节 时间函数_第4页
第4页 / 共8页
第十二节 时间函数_第5页
第5页 / 共8页
点击查看更多>>
资源描述

《第十二节 时间函数》由会员分享,可在线阅读,更多相关《第十二节 时间函数(8页珍藏版)》请在金锄头文库上搜索。

1、Date & Time functionsCurTime()Day()DayOfWeek()DayOfYear()Hour()LocalTime()Minute()Month()Seconds()TimeDay()TimeDayOfWeek()TimeDayOfYear()TimeHour()TimeMinute()TimeMonth()TimeSeconds()TimeYear()Year()datetime CurTime()Returns last known servers time, number of seconds elapsed from 00:00 January 1, 19

2、70.Sample if(CurTime() - OrderOpenTime()360) return(0);int Day()Returns current dates day of month.Sample if(Day()= 12 | Hour()17) is_siesta=true;datetime LocalTime()Returns local computer time, number of seconds elapsed from 00:00 January 1, 1970.Sample if(ServerTime() - OrderOpenTime()360) return(

3、0);int Minute()Returns current minute (0,1,2,.59).Sample if(Minute()=15) return(first quarter);int Month()Returns current month as number (1-January,2,3,4,5,6,7,8,9,10,11,12).Sample if(Month()=5) return(first half of year);int Seconds()Returns current second (0,1,2,.59).Sample if(Seconds()=15) retur

4、n(0);int TimeDay(datetimedate)Returns day of month (1 - 31) for specified date.Parametersdate - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int day = TimeDay(D2003.12.31); / day is 31int TimeDayOfWeek(datetimedate)Returns zero based day of week (0-Sunday,1

5、,2,3,4,5,6) for specified date.Parametersdate - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int weekday = TimeDayOfWeek(D2004.11.2); / day is 1 - tuesdayint TimeDayOfYear(voiddate)Returns day (1-1 january,.,365(6) - 31 december) of year for specified date.

6、Parametersdate - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int day = TimeDayOfYear(CurTime();int TimeHour(datetimetime)Returns hour for specified time.Parameterstime - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sampl

7、e int h = TimeHour(CurTime();int TimeMinute(datetimetime)Returns minute for specified time.Parameterstime - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int m = TimeMinute(CurTime();int TimeMonth(datetimetime)Returns month for specified time.Parameterstime

8、- Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int m = TimeMonth(CurTime();int TimeSeconds(datetimetime)Returns seconds for specified time.Parameterstime - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int m = TimeS

9、econds(CurTime();int TimeYear(datetimetime)Returns year for specified date. Return values can be in range 1970-2037.Parameterstime - Datetime is number of seconds elapsed since midnight (00:00:00), January 1, 1970.Sample int y = TimeYear(CurTime();int Year()Returns current year.Sample / return if da

10、te before 1 May 2002 if(Year()=2002 & Month()5) return(0);日期时间函数 Date & Time Functionsdatetime CurTime( )返回当前时间示例:if(CurTime()-OrderOpenTime()360) return(0);int Day()返回当前日期示例:if(Day()=12 | Hour()17)is_siesta=true;datetime LocalTime()返回当前电脑时间示例:if(LocalTime()-OrderOpenTime()360) return(0);int Minute(

11、)返回当前分钟示例:if(Minute()=15)return(first quarter);int Month()返回当前月份示例:if(Month()=5)return(first half of year);int Seconds()返回当前秒数示例:if(Seconds()=15)return(0);int TimeDay( datetime date)返回输入日期中的日期 : 输入参数date - 输入日期 示例:int day=TimeDay(D2003.12.31);/ day is 31int TimeDayOfWeek( datetime date)返回输入日期中的日期是星期

12、几 (0-6) : 输入参数date - 输入日期 示例:int weekday=TimeDayOfWeek(D2004.11.2);/ day is 2 - tuesdayint TimeDayOfYear( datetime date)返回输入日期中的日期在当年中的第几天 : 输入参数date - 输入日期 示例:int day=TimeDayOfYear(CurTime();int TimeHour( datetime time)返回输入日期中的小时 : 输入参数date - 输入日期 示例:int h=TimeHour(CurTime();int TimeMinute( datetime time)返回输入日期中的分钟 : 输入参数date - 输入日期 示例:int m=TimeMinute(CurTime();

展开阅读全文
相关资源
相关搜索

当前位置:首页 > 商业/管理/HR > 销售管理

电脑版 |金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号