Difference between revisions of "Working With Date and Time Data in Recital"

Revision as of 14:53, 22 October 2009

Working With Date and Time Data in Recital

Date and Time Conversion Functions

See Also

Table of Contents

• CTOD() -
• CTOT() -
• DATE() -
• DATETIME() -
• DAYS() -
• DMY() -
• DTOC() -
• DTOM() -
• DTOS() -
• MDY() -
• MTOD() -
• STOD() -
• TSTRING() -
• TTOC() -
• TTOD() -

Miscellaneous Date and Time Functions

See Also

Table of Contents

• AMPM() - return 12-hour clock time as a character string followed by "am" or "pm"
• CDOW() - return the character day of week from a date or datetime
• CMONTH() - return the character month from a date or datetime
• DATE() - return the system date as a date
• DATETIME() - return the system date and time as a datetime
• DAY() - return the numeric day of the month from a date or datetime
• DOW() - return the numeric day of the week from a date or datetime
• ELAPTIME() - return time difference between two time strings as a time string
• EPOCH() - return the current SET EPOCH setting
• GOMONTH() - return a date a specified number of months before or after a date or datetime
• HOUR() - return the numeric hours from a datetime
• HOURS() - return the numeric hours from a time string
• MINUTE() - return the numeric minutes from a datetime
• MINUTES() - return the numeric minutes from a time string
• MONTH() - return the numeric month from a date or datetime
• QUARTER() - return the numeric year quarter from a date or datetime
• SEC() - return the numeric seconds from a datetime
• SECONDS() - return the numeric seconds from the current time or a time string
• SECS() - return the numeric seconds from a time string
• TIME() - return the system time as a time string
• TIMESTAMP() - return the system date and time
• VALIDTIME() - check the validity of a time string
• WEEK() - return the numeric week from a date or datetime
• YEAR() - return the numeric year from a specified date or datetime

Summary