MicroStrategy ONE
SQL Time Format
The SQL Time Format property allows you to determine the format of the time literal accepted in SQL statements. This is a database-specific property; some examples are shown in the table below.
Example
| Database Type | Time Format |
|
Default |
yyyy-mm-dd hh:nn:ss |
|
Microsoft SQL Server |
mm/dd/yyyy hh:nn:ss |
|
Oracle |
mm/dd/yyyy hh:nn:ss |
|
Sybase IQ |
hh:nn:ss:lll |
Levels at Which You Can Set This
Database instance, template, and report