The default format for the display of time values by Data Vault SQL clients (including ssasql) is as follows:
hh:mm:ss
That is, an eight-character string consisting of a two-digit hour (0-23), a two-digit minutes figure (0-59), and a two-digit seconds figure (0-31), with components separated by colons ( : ). For example, for 10 minutes past 2 pm, ssasql will display 14:10:00.
The time picture can be customized by including a
TimePic
entry in the [CLIENT] section of the client-side nucleus.ini file.