Difference between revisions of "Working With Date and Time Data in Recital"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) (→Miscellaneous Date and Time Functions) |
Yvonnemilne (Talk | contribs) (→Working With Date and Time Data in Recital) |
||
Line 8: | Line 8: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
− | * [[CTOD()]] - perform character to date conversion | + | * [[CTOD()|ctod()]] - perform character to date conversion |
− | * [[CTOT()]] - perform character to datetime conversion | + | * [[CTOT()]|ctot()] - perform character to datetime conversion |
− | * [[DATE()]] - perform numeric year,month,day to date conversion | + | * [[DATE()|date()]] - perform numeric year,month,day to date conversion |
− | * [[DATETIME()]] - perform numeric year,month,day to datetime conversion | + | * [[DATETIME()|datetime()]] - perform numeric year,month,day to datetime conversion |
− | * [[DAYS()]] - perform numeric seconds to numeric whole days conversion | + | * [[DAYS()|days()]] - perform numeric seconds to numeric whole days conversion |
− | * [[DMY()]] - perform date to character (DMY) conversion | + | * [[DMY()|dmy()]] - perform date to character (DMY) conversion |
− | * [[DTOC()]] - perform date to character conversion | + | * [[DTOC()|dtoc()]] - perform date to character conversion |
− | * [[DTOM()]] - perform date to string (DD-Mmm-YYYY) conversion | + | * [[DTOM()|dtom()]] - perform date to string (DD-Mmm-YYYY) conversion |
− | * [[DTOS()]] - perform date to string conversion | + | * [[DTOS()|dtos()]] - perform date to string conversion |
− | * [[MDY()]] - perform date to character (MDY) conversion | + | * [[MDY()|mdy()]] - perform date to character (MDY) conversion |
− | * [[MTOD()]] - perform string (DD-Mmm-YYYY) to date conversion | + | * [[MTOD()|mtod()]] - perform string (DD-Mmm-YYYY) to date conversion |
− | * [[STOD()]] - perform string to date conversion | + | * [[STOD()|stod()]] - perform string to date conversion |
− | * [[TSTRING()]] - perform numeric seconds to time string conversion | + | * [[TSTRING()|tstring()]] - perform numeric seconds to time string conversion |
− | * [[TTOC()]] - perform datetime to string conversion | + | * [[TTOC()|ttoc()]] - perform datetime to string conversion |
− | * [[TTOD()]] - perform datetime to date conversion | + | * [[TTOD()|ttod()]] - perform datetime to date conversion |
===Miscellaneous Date and Time Functions=== | ===Miscellaneous Date and Time Functions=== | ||
Line 32: | Line 32: | ||
'''Table of Contents''' | '''Table of Contents''' | ||
− | * [[AMPM()]] - return 12-hour clock time as a character string followed by "am" or "pm" | + | * [[AMPM()|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 | + | * [[CDOW()]|cdow()] - return the character day of week from a date or datetime |
− | * [[CMONTH()]] - return the character month from a date or datetime | + | * [[CMONTH()|cmonth()]] - return the character month from a date or datetime |
− | * [[DATE()]] - return the system date as a date | + | * [[DATE()|date()]] - return the system date as a date |
− | * [[DATETIME()]] - return the system date and time as a datetime | + | * [[DATETIME()|datetime()]] - return the system date and time as a datetime |
− | * [[DAY()]] - return the numeric day of the month from a date or datetime | + | * [[DAY()|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 | + | * [[DOW()|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 | + | * [[ELAPTIME()|elaptime()]] - return time difference between two time strings as a time string |
− | * [[EPOCH()]] - return the current [[SET EPOCH]] setting | + | * [[EPOCH()|epoch()]] - return the current [[SET EPOCH]] setting |
− | * [[GOMONTH()]] - return a date a specified number of months before or after a date or datetime | + | * [[GOMONTH()|gomonth()]] - return a date a specified number of months before or after a date or datetime |
− | * [[HOUR()]] - return the numeric hours from a datetime | + | * [[HOUR()|hour()]] - return the numeric hours from a datetime |
− | * [[HOURS()]] - return the numeric hours from a time string | + | * [[HOURS()|hours()]] - return the numeric hours from a time string |
− | * [[MINUTE()]] - return the numeric minutes from a datetime | + | * [[MINUTE()|minute()]] - return the numeric minutes from a datetime |
− | * [[MINUTES()]] - return the numeric minutes from a time string | + | * [[MINUTES()|minutes()]] - return the numeric minutes from a time string |
− | * [[MONTH()]] - return the numeric month from a date or datetime | + | * [[MONTH()|month()]] - return the numeric month from a date or datetime |
− | * [[QUARTER()]] - return the numeric year quarter from a date or datetime | + | * [[QUARTER()|quarter()]] - return the numeric year quarter from a date or datetime |
− | * [[SEC()]] - return the numeric seconds from a datetime | + | * [[SEC()|sec()]] - return the numeric seconds from a datetime |
− | * [[SECONDS()]] - return the numeric seconds from the current time or a time string | + | * [[SECONDS()|seconds()]] - return the numeric seconds from the current time or a time string |
− | * [[SECS()]] - return the numeric seconds from a time string | + | * [[SECS()|secs()]] - return the numeric seconds from a time string |
− | * [[TIME()]] - return the system time as a time string | + | * [[TIME()|time()]] - return the system time as a time string |
− | * [[TIMESTAMP()]] - return the system date and time | + | * [[TIMESTAMP()|timestamp()]] - return the system date and time |
− | * [[VALIDTIME()]] - check the validity of a time string | + | * [[VALIDTIME()|validtime()]] - check the validity of a time string |
− | * [[WEEK()]] - return the numeric week from a date or datetime | + | * [[WEEK()|week()]] - return the numeric week from a date or datetime |
− | * [[YEAR()]] - return the numeric year from a specified date or datetime | + | * [[YEAR()|year()]] - return the numeric year from a specified date or datetime |
===Summary=== | ===Summary=== |
Revision as of 10:09, 23 October 2009
Contents
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()]|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()]|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