Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Datetime and Numeric Formatting Overview

Datetime and Numeric Formatting Overview

You can specify the default search and display formats for datetime values in data discovery searches and results.
You can also specify the data format for numeric and datetime columns when you define search options for an entity in Data Discovery. The data format determines how Data Archive displays the data in Data Vault search and browse data search results.
Enter datetime formats through a format string that contains one or more alphabetic characters. Data Archive interprets alphabetic characters in a format string as the components of a date or time value unless you enclose them within single quotation marks. Data Archive interprets characters that appear within single quotation marks as literal strings. It also interprets nonalphabetic characters as literal strings. For example, Data Archive interprets the letter
E
in a format string as the day of the week, but it interprets
'E'
as the letter "E."
Enter numeric formats through a format string that contains one or more reserved characters. Data Archive interprets the reserved characters as the components of a numeric value unless you enclose them within single quotation marks. Data Archive interprets characters that appear within single quotation marks and characters that are not reserved characters as literal strings. For example, Data Archive interprets
#
as one digit, but it interprets
'#'
as the pound sign character. If you do not enter a numeric format string, Data Archive displays the number as it appears in the database.

0 COMMENTS

We’d like to hear from you!