Difference between revisions of "Working With Date and Time Data in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Working With Date and Time Data in Recital) |
Yvonnemilne (Talk | contribs) (→Date and Time Conversion Functions) |
||
| Line 6: | Line 6: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
| − | * [[CTOD()]] - | + | * [[CTOD()]] - perform character to date conversion |
| − | * [[CTOT()]] - | + | * [[CTOT()]] - perform character to datetime conversion |
| − | * [[DATE()]] - | + | * [[DATE()]] - perform numeric year,month,day to date conversion |
| − | * [[DATETIME()]] - | + | * [[DATETIME()]] - perform numeric year,month,day to datetime conversion |
| − | * [[DAYS()]] - | + | * [[DAYS()]] - perform numeric seconds to numeric whole days conversion |
| − | * [[DMY()]] - | + | * [[DMY()]] - perform date to character (DMY) conversion |
| − | * [[DTOC()]] - | + | * [[DTOC()]] - perform date to character conversion |
| − | * [[DTOM()]] - | + | * [[DTOM()]] - perform date to string (DD-Mmm-YYYY) conversion |
| − | * [[DTOS()]] - | + | * [[DTOS()]] - perform date to string conversion |
| − | * [[MDY()]] - | + | * [[MDY()]] - perform date to character (MDY) conversion |
| − | * [[MTOD()]] - | + | * [[MTOD()]] - perform string (DD-Mmm-YYYY) to date conversion |
| − | * [[STOD()]] - | + | * [[STOD()]] - perform string to date conversion |
| − | * [[TSTRING()]] - | + | * [[TSTRING()]] - perform numeric seconds to time string conversion |
| − | * [[TTOC()]] - | + | * [[TTOC()]] - perform datetime to string conversion |
| − | * [[TTOD()]] - | + | * [[TTOD()]] - perform datetime to date conversion |
===Miscellaneous Date and Time Functions=== | ===Miscellaneous Date and Time Functions=== | ||
Revision as of 15:06, 22 October 2009
Contents
Working With Date and Time Data in Recital
Date and Time Conversion Functions
See Also
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
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
