MSCEWI2044
Warning loss of decimal precision in time.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
Fractional seconds are only displayed if it is explicitly set in the TIME_OUTPUT_FORMAT session parameter.
Example Code
Input Code:
select current_timestamp(4) at local;
Output Code:
SELECT
current_timestamp(4) /*** MSC-WARNING - MSCEWI2044 - FRACTIONAL SECONDS ARE ONLY DISPLAYED IF IS EXPLICITLY SET IN THE TIME_OUTPUT_FORMAT SESSION PARAMETER. ***/;
Recommendations
Check if the TIME_OUTPUT_FORMAT session parameter is set to get the behavior that you want.
If you need more support, you can email us at [email protected]
Last updated