Date and Time Functions
Procedures that work with dates and time.
Description:
These procedures provide ways to deal with date and time intervals in a consistent way. Additional procedures are provided to set and get the current system date and time, and to retrieve a time stamp for sensitive timing algorithms.
VisualBasic compatible procedures
Procedures for working with so-called date serials, similar to those used in Visual Basic(r).
Date and time procedures
Procedures for working with the system date and time.
VisualBasic compatible procedures
Extracting information from Date serials
Extracting information from Date serials
Miscellaneous
NOW
Creating Date serialsDATESERIAL
Gets the date serial representation of a date.
TIMESERIAL
Gets the date serial representation of a time.
DATEVALUE
TIMEVALUE
SECOND
Gets the seconds of the hour from a date serial.
MINUTE
Gets the minutes of the hour from a date serial.
HOUR
Gets the hour of the day from a date serial.
DAY
Gets the day of the month from a date serial.
WEEKDAY
Gets the day of the week from a date serial.
MONTH
Gets the month of the year from a date serial.
YEAR
Gets the year from a date serial.
DATEPART
Miscellaneous
ISDATE
MONTHNAME
Gets the month name of its integer representation.
WEEKDAYNAME
Gets the weekday name of its integer representation.
Back to Table of Contents
