MSCEWI2044

Warning loss of decimal precision in time.

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.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2043

MSCEWI2045

Last modified 1yr ago