MicroStrategy ONE
Timestamp Format
The Timestamp Format property allows you to determine the format of the timestamp literal accepted in the WHERE clause. This is a database-specific property; some examples are shown in the table below.
Levels at Which You Can Set This
Database instance, report, and template
Example
|
Default |
yyyy-mm-dd hh:nn:ss |
|
DB2 |
yyyy-mm-dd-hh.nn.ss |
|
RedBrick |
mm/dd/yyyy hh:nn:ss |