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.