db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nelson Rodrigues (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-4106) The INTEGER function doen't return an integer representation of a date
Date Sat, 21 Mar 2009 12:14:50 GMT
The INTEGER function doen't return an integer representation of a date
----------------------------------------------------------------------

                 Key: DERBY-4106
                 URL: https://issues.apache.org/jira/browse/DERBY-4106
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.4.2.0
         Environment: MS Windows XP Professional Version 2002 Service Pack 2, running NetBeans
IDE 6.5 
            Reporter: Nelson Rodrigues


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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message