MSCEWI2043

Default decimal precision in the Convert Timezone is three digits.

Severity

Low

Description

CONVERT_TIMEZONE default decimal precision is three digits. TIME_OUTPUT_FORMAT session parameter can be modified to get different results.

Example Code

Input Code:

SELECT CURRENT_TIMESTAMP AT TIME ZONE 'America Pacific';

Output Code;

SELECT
CONVERT_TIMEZONE('America/Tijuana', CURRENT_TIMESTAMP) /*** MSC-WARNING - MSCEWI2043 - CONVERT_TIMEZONE DEFAULT DECIMAL PRECISION IS TREE DIGITS. ***/;

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.