Working With Date and Time Data in Recital

Working With Date and Time Data in Recital

Certain set commands change the date format:

• set century - enable or disable inclusion of the century

set century on | off

• set date - define the date format

set date [to] american | ansi | british | dmy | french | german | iso | italian | japan | mdy | usa | ymd

• set epoch - specify a one hundred-year epoch to allow for two digit years

set epoch to <start-year as numeric>

• set mark - specify the separator character in dates

set mark to [<separator as character>]

Date and Time Conversion Functions

• ctod() - perform character to date conversion

date = ctod(string as character)

• ctot() - perform character to datetime conversion

datetime = ctot(string as character)

• date() - perform numeric year, month , day to date conversion

date = date(year as numeric, month as numeric, day as numeric)

• datetime() - perform numeric year, month, day to datetime conversion

datetime = datetime(year as numeric, month as numeric, day as numeric)

• days() - perform numeric seconds to numeric whole days conversion

numeric = days(seconds as numeric)

• dmy() - perform date to character (DMY) conversion

string = dmy(date as date)

• dtoc() - perform date to character conversion

string = dtoc(date as date)

• dtom() - perform date to string (DD-Mmm-YYYY) conversion

string = dtom(date as date)

• dtos() - perform date to string conversion

string = dtos(date as date)

• mdy() - perform date to character (MDY) conversion

string = mdy(date as date)

• mtod() - perform string (DD-Mmm-YYYY) to date conversion

date = mtod(string as character)

• stod() - perform string to date conversion

date = stod(string as character)

• tstring() - perform numeric seconds to time string conversion

string = tstring(seconds as numeric)

• ttoc() - perform datetime to string conversion

string = ttoc(datetime as datetime)

• ttod() - perform datetime to date conversion

date = ttod(datetime as datetime)

Miscellaneous Date and Time Functions

• ampm() - return 12-hour clock time as a character string followed by "am" or "pm"

character = ampm()

• cdow() - return the character day of week from a date or datetime

character = cdow(date as date | datetime as datetime)

• cmonth() - return the character month from a date or datetime

character = cmonth(date as date | datetime as datetime)

• date() - return the system date as a date

date = date()

• datetime() - return the system date and time as a datetime

datetime = datetime()

• day() - return the numeric day of the month from a date or datetime

numeric = day(date as date | datetime as datetime)

• dow() - return the numeric day of the week from a date or datetime

numeric = dow(date as date | datetime as datetime)

• elaptime() - return time difference between two time strings as a time string

character = elaptime(start-time as character | end-time as character)

• epoch() - return the current set epoch setting

numeric = epoch()

• gomonth() - return a date a specified number of months before or after a date or datetime

date = gomonth(date as date, months as numeric)
</pre

* [[HOUR()|hour()]] - return the numeric hours from a datetime

<pre>
numeric = hour(datetime as datetime)

• hours() - return the numeric hours from a time string

numeric = hours(time as character)

• minute() - return the numeric minutes from a datetime

numeric = minute(datetime as datetime)

• minutes() - return the numeric minutes from a time string

numeric = minutes(time as character)

• month() - return the numeric month from a date or datetime

numeric = month(date as date | datetime as datetime)

• quarter() - return the numeric year quarter from a date or datetime

numeric = quarter(date as date | datetime as datetime)

• sec() - return the numeric seconds from a datetime

numeric = sec(datetime as datetime)

• seconds() - return the numeric seconds from the current time or a time string

numeric = seconds([time as character])

• secs() - return the numeric seconds from a time string

numeric = minutes(time as character)

• time() - return the system time as a time string

character = time([include-hundredths as numeric])

• timeofday() - return the system date and time

character = timeofday([format as numeric])

• timestamp() - return the system date and time

character = timestamp([format as numeric])

• validtime() - check the validity of a time string

logical = validtime(time as character)

• week() - return the numeric week from a date or datetime

numeric = week(date as date | datetime as datetime)

• year() - return the numeric year from a specified date or datetime

numeric = year(date as date | datetime as datetime)