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.

MSCEWI2042

MSCEWI2044

Last modified 1yr ago