MSCEWI2043

Default decimal precision in the Convert Timezone is three digits.

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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.

• If you need more support, you can email us at [email protected]