select (interval '56:48'  minute to second);
result:00:56:48
select (interval '-56:48'  minute to second);
result:-56:48:00
select (interval '+56:48'  minute to second);
result:56:48:00



When user uses ‘+’ or ‘-‘ symbol, then minute to second range is getting
ignored.



I have checked the code and found that in function DecodeInterval(), for
timezone case (DTK_TZ) it uses INTERVAL_FULL_RANGE irrespective of range
passed by user.

However if use the range passed as argument in function DecodeInterval(),
the result of using ‘+’ or ‘-‘ is same as without using it.

Is there any particular reason for ignoring the range for DTK_TZ case in
DecodeInterval() function?





With Regards,

Amit Kapila



Reply via email to