5.4日期和时间函数 1. Date 12. Now 2. DateAdd(interval, number, date)13. Second(time) 3. Date Diff(interval, date1, date2L, 14. Time firstdayofweekL, firstweekofyear]) 5. Timer 4. DatePart(interval, dateL firstday- 16. Time Serial(hour, ofweekl, firstweekofyear]) minute, second) 5. Date Serialyear, month, day) 17. Time Value(time) 6. Date Value(date) 18. Weekday(date, 7. Day(date) Ifirstdayofweekl) 8. Hour(time) 19. Weekday Name weekday, 9. Minute(time) abbreviate, firstdayofweek 10. Month(date) 20. Year(date) 11. MonthName(monthL abbreviated) 返国单②5 . 4 日期和时间函数 1．Date 2．DateAdd(interval, number, date) 3．DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) 4．DatePart(interval,date[,firstday￾ofweek[, firstweekofyear]]) 5．DateSerial(year, month, day) 6．DateValue(date) 7．Day(date) 8．Hour(time) 9．Minute(time) 10．Month(date) 11．MonthName(month[, abbreviate]) 12．Now 13．Second(time) 14．Time 15．Timer 16．TimeSerial(hour, minute, second) 17．TimeValue(time) 18．Weekday(date, [firstdayofweek]) 19．WeekdayName(weekday, abbreviate, firstdayofweek) 20．Year(date)