db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "George Baklarz (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-161) DATE function as documented in the manuals does not support integer arguments. i.e. DATE(1232) does not work although the manual specifies that this format will return a date field that is "x" number of days since day 0.
Date Fri, 04 Mar 2005 19:44:46 GMT
DATE function as documented in the manuals does not support integer arguments. i.e. DATE(1232)
does not work although the manual specifies that this format will return a date field that
is "x" number of days since day 0.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-161
         URL: http://issues.apache.org/jira/browse/DERBY-161
     Project: Derby
        Type: Bug
  Components: SQL  
    Versions: 10.0.2.0    
 Environment: Windows XP Professional SP 1
    Reporter: George Baklarz
    Priority: Minor


The DATE function returns a date from a value. The argument must be a date, timestamp, a positive
number less than or equal to 3,652,059, a valid string representation of a date or timestamp,
or a string of length 7 that is not a CLOB or LONG VARCHAR. If the argument is a string of
length 7, it must represent a valid date in the form yyyynnn, where yyyy are digits denoting
a year, and nnn are digits between 001 and 366, denoting a day of that year. The result of
the function is a date. If the argument can be null, the result can be null; if the argument
is null, the result is the null value. The other rules depend on the data type of the argument
specified: 
  - If the argument is a date, timestamp, or valid string representation of a date or timestamp:
The result is the date part of the value. 
  - If the argument is a number: The result is the date that is n-1 days after January 1,
0001, where n is the integral part of the number. 
  - If the argument is a string with a length of 7: The result is the date represented

The DATE function does not support integer argument.

ij> values date(12345);
ERROR 42846: Cannot convert types 'INTEGER' to 'DATE'.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message