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.