Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section



[SQL]    TimePrecision=n


The value n is the default time precision for the Time component of the value returned by the SQL Scalar functions GETDATE(), CURRENT_TIME, and CURRENT_TIMESTAMP. The precision is expressed as the number of decimal places allowed for the millisecond portion of the time value.



Range of Values

0–9. The default is 0, which means milliseconds are not returned in the time value.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Default Time Precision for GETDATE, CURRENT_TIME, and CURRENT_TIMESTAMP setting, enter a number of decimal places.