db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Resolved: (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, 29 Apr 2005 00:44:06 GMT
     [ http://issues.apache.org/jira/browse/DERBY-161?page=all ]
     
Satheesh Bandaram resolved DERBY-161:
-------------------------------------

     Resolution: Fixed
    Fix Version: 10.1.0.0

Submitted Jack's patch for datetime issues. That should solve this.

> 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
>      Fix For: 10.1.0.0

>
> 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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message