MSCEWI2043
Default decimal precision in the Convert Timezone is three digits.
Low
CONVERT_TIMEZONE default decimal precision is three digits. TIME_OUTPUT_FORMAT session parameter can be modified to get different results.
SELECT CURRENT_TIMESTAMP AT TIME ZONE 'America Pacific';
SELECT
CONVERT_TIMEZONE('America/Tijuana', CURRENT_TIMESTAMP) /*** MSC-WARNING - MSCEWI2043 - CONVERT_TIMEZONE DEFAULT DECIMAL PRECISION IS TREE DIGITS. ***/;
- 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.
Last modified 1yr ago