RETS 1.9 defines the following date/time functions, YEAR, MONTH,DAY, and WEEKDAY. The following functions were added to extend the date/time segmentation capabilities:
- HOUR – returns the hour as an integer from the Date/Time provided
- MINUTE - returns the minutes as an integer from the Date/Time provided
- SECOND - returns the seconds as an integer from the Date/Time provided
- DAYS – Days separation between to Date/Time values as a floating point value with fractional days.
- DATEONLY – Zeros out the time portion of the date/time value provided.