[TAJO-763] Out of range problem in utc_usec_to()

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.8.0, 0.9.0
• Fix Version/s: 0.8.0, 0.9.0
• Component/s: Function/UDF
• Assignee: Ilhyun Suh
• Reporter: Jihoon Son
• Created: 14/Apr/14 14:46
• Updated: 19/Apr/14 05:00
• Resolved: 19/Apr/14 04:47

Description

When I run the following query using the utc_usec_to function, I met an out of range error.
Since this problem occurs only when converting to hour, it seems to relate with the time zone.

default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05 08:00:00')::INT8*1000);
result: 1 rows (9 B)
?utc_usec_to
-------------------------------
1365116400000000

default> select utc_usec_to('hour', (TIMESTAMP '2013-04-05 09:00:00')::INT8*1000);
Value 24 for hourOfDay must be in the range [0,23]