Working With Date and Time Data in Lianja
From Lianjapedia
(Redirected from Working With Date and Time Data in Recital)
Working With Date and Time Data in Lianja
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)
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)
- hour() - return the numeric hours from a datetime
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)