InterSystems IRIS Data Platform 2019.2  /  Configuration Parameter File Reference

Configuration Parameter File Reference
Previous section           Next section
InterSystems: The power behind what matters   

Set the default time precision for SQL scalar time functions.
[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 > SQL, for the Default time precision for GETDATE, CURRENT_TIME, and CURRENT_TIMESTAMP setting, enter a number of decimal places.

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-23 06:48:00