Working With Date and Time Data in Recital

Working With Date and Time Data in Recital

Date and Time Conversion Functions

See Also

Certain set commands change the date format: set century, set date, set epoch and set mark.

Table of Contents

• ctod() - perform character to date conversion
• ctot() - perform character to datetime conversion
• date() - perform numeric year,month,day to date conversion
• datetime() - perform numeric year,month,day to datetime conversion
• days() - perform numeric seconds to numeric whole days conversion
• dmy() - perform date to character (DMY) conversion
• dtoc() - perform date to character conversion
• dtom() - perform date to string (DD-Mmm-YYYY) conversion
• dtos() - perform date to string conversion
• mdy() - perform date to character (MDY) conversion
• mtod() - perform string (DD-Mmm-YYYY) to date conversion
• stod() - perform string to date conversion
• tstring() - perform numeric seconds to time string conversion
• ttoc() - perform datetime to string conversion
• ttod() - perform datetime to date conversion

Miscellaneous Date and Time Functions

See Also

Certain set commands change the date format: set century, set date, set epoch and set mark.

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