[DERBY-4106] The Reference Gulde claims that the INTEGER function can be applied to dates and times

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.2.0
• Fix Version/s: 10.6.1.0
• Component/s: Documentation
• Environment: MS Windows XP Professional Version 2002 Service Pack 2, running NetBeans IDE 6.5
• Urgency: Normal
• Assignee: Bryan Pendleton
• Reporter: Nelson Rodrigues
• Created: 21/Mar/09 12:14
• Updated: 21/Jan/11 17:52
• Resolved: 10/Nov/09 02:06

Description

When Derby Reference Manual, version 10.4, explains the INTEGER function is said that:

"The INTEGER function returns an integer representation of a number, character string,
DATE, or time in the form of an integer constant"

But when I try to convert a DATE to INTEGER I receive an sqlstate 42846: "Cannot convert types 'DATE' to 'INTEGER'."

This is a sample query where the expected result is the integer number 1:

select integer(date(1)) from SYSIBM.SYSDUMMY1

Issue Links

• relates to: DERBY-4107 The Reference Guide incorrectly describes the behavior of the DATE function when applied to an integer argument