Working With Date and Time Data in Recital

From Recital Documentation Wiki
Revision as of 15:09, 22 October 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

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

Summary