Generates and returns a DATETIME value constructed from the arguments you supply.
Datetime = MakeDateTime (iYear, iMonth, iDay [,iHour, iMinute, iSecond, iMicrosec])
Variable | Description |
---|---|
Datetime | The generated date and time. DATETIME. |
iYear | The full year value (century included). INTEGER. |
iMonth | The month (1 - 12). INTEGER. |
iDay | The day (1 - 31). INTEGER. |
iHour | Optional: The hour value in 24-hour format (0 - 23). INTEGER. |
iMinute | Optional: The minute (0 - 59). INTEGER. |
iSecond | Optional: The second (0 - 59). INTEGER. |
iMicrosec | Optional: The microsecond (0 - 9999999). INTEGER. |
The DATETIME data type represents values from 4713 BC to 19999 AD. Use a negative value to represent BC dates.
If you do not specify the optional parameters, this function sets the time to midnight.
// Specify a date of Jan. 2, 1996 at 8:15 AM datetime = MakeDateTime (1996, 1, 2, 8, 15)