Documentation dev:appendix:reference https://www.omnidex.com/docs/v54/ 2026-04-30T07:14:24+0000 Documentation https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) dev:appendix:reference:datatypes https://www.omnidex.com/docs/v54/doku.php?id=dev:appendix:reference:datatypes&rev=1467153531&do=diff Appendix Appendix | Reference | Omnidex Datatypes Omnidex Datatypes Omnidex supports a wide variety of datatypes, including standard ANSI datatypes, Omnidex-specific datatypes and RDBMS-specific datatypes. Standard Datatypes Omnidex supports the following standard datatypes: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) dev:appendix:reference:datatypes_insert https://www.omnidex.com/docs/v54/doku.php?id=dev:appendix:reference:datatypes_insert&rev=1467153531&do=diff Datatype Class Description CHARACTER(n) STRING Space-filled character string of n characters CHAR(n) STRING Synonym for CHARACTER(n) text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) dev:appendix:reference:date_tokens https://www.omnidex.com/docs/v54/doku.php?id=dev:appendix:reference:date_tokens&rev=1467153531&do=diff Appendix Appendix | Reference | Omnidex Date Tokens Omnidex Date Tokens Omnidex supports a series of date tokens that represent portions of a date datatype. These tokens are used in a variety of date-oriented functions, such as EXTRACT, $CALC_DATE and $COMPARE_DATES. Date Token Return Datatype Description text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) dev:appendix:reference:date_tokens_insert https://www.omnidex.com/docs/v54/doku.php?id=dev:appendix:reference:date_tokens_insert&rev=1467153531&do=diff Date Token Return Datatype Description YEAR INTEGER Returns Year in CCYY format. MONTH INTEGER Returns numeric Month from 1 to 12. DAY INTEGER Returns numeric Day of the Month. HOUR INTEGER Returns numeric Hour. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) dev:appendix:reference:natl_datatypes_insert https://www.omnidex.com/docs/v54/doku.php?id=dev:appendix:reference:natl_datatypes_insert&rev=1467153531&do=diff Datatype Class Description NATIONAL CHARACTER(n) STRING Space-filled character string of n characters NATIONAL CHAR(n) STRING Synonym for CHARACTER(n)