LucidDbAppLib
From Eigenpedia
Contents |
[edit]
Overview
This page is an index for the LucidDB application library (applib), a collection of commonly needed application routines packaged with LucidDB. For system-management routines (some of which may also be useful for application purposes), see LucidDbSystemProcedures.
[edit]
Numeric Routines
[edit]
String Routines
[edit]
Date/Time Routines
- ADD_DAYS
- ADD_HOURS
- CALENDAR_QUARTER
- CHAR_TO_DATE
- CHAR_TO_TIME
- CHAR_TO_TIMESTAMP
- CONVERT_DATE
- CURRENT_DATE_IN_JULIAN
- DATE_TO_CHAR
- DAY_FROM_JULIAN_START
- DAY_IN_YEAR
- DAY_NUMBER_OVERALL
- DAYS_DIFF
- DERIVE_EFFECTIVE_TO_TIMESTAMP
- FISCAL_MONTH
- FISCAL_TIME_DIMENSION
- FISCAL_QUARTER
- FISCAL_YEAR
- HOURS_DIFF
- JULIAN_DAY_TO_DATE
- JULIAN_DAY_TO_TIMESTAMP
- PADWEEKNUMBER
- TIME_DIMENSION
- TIME_TO_CHAR
- TIMESTAMP_TO_CHAR
[edit]
Phone Number Routines
[edit]
Security-Related Routines
[edit]
ANALYZE Routines
[edit]
Row/Column Transformations
- COLLAPSE_ROWS
- CONTIGUOUS_VALUE_INTERVALS
- FLATTEN_RECURSIVE_HIERARCHY
- FLATTEN_RECURSIVE_HIERARCHY_ALL_LEVELS
- GENERATE_CRC
- PENULTIMATE_VALUES
- PIVOT_COLUMNS_TO_ROWS
- SPLIT_STRINGS
- TOPN
[edit]
