About the Data Vault Administrator Guide
Introduction to the Data Vault
Data Vault Service Startup and Shutdown
Data Vault Configuration
Data Vault SSL Setup
Data Vault ODBC Setup
Data Vault Administration
Data Repartitioning
Partial Data Vault Copy
Archived Data Migration
Data Validation
Bulk File Uploader
Data Vault Administration Tool
Data Vault Logs
User Account Privileges
ssasql Command Line Program
Data Vault Audit Log
Appendix A: Sample Configuration Files
- ssa.ini
- nucleus.ini

Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Date Picture Display Format

The default format for the display of date values by Data Vault SQL clients (including ssasql) is as follows:

yyyy-mm-dd

That is, a ten-character string consisting of a four-digit year, a two-digit month number (1-12), and a two-digit day number (1-31), with components separated by hyphens ( - ). For example, for the date July 1, 2002, ssasql will display 2002-07-01.

The date picture can be customized by including a DatePic
entry in the [CLIENT] section of the client-side nucleus.ini file.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Date Picture Display Format

Date Picture Display Format