Hello.
Through translation of Derby Reference manual, I found question around
description of DAY function.
http://db.apache.org/derby/docs/dev/ref/rrefdayfunc.html
The manual told as next :
The argument must be a date, timestamp, or a valid character string
representation of a date or timestamp that is not a CLOB, LONG VARCHAR,
or XML value.
The description above told that argument is limited to date, timestamp,
character string which represents date or timestamp.
However, next description exists in the same page :
If the argument is a time duration or timestamp duration: The result is
the day part of the value, which is an integer between -99 and 99. A
nonzero result has the same sign as the argument.
The second description refers that duration which can be argument of the
DAY function.
Question is, can the argument of DAY function be duration ?
If it can, how is duration passed to DAY function ?
Best regards.
--
/*
Tomohito Nakayama
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Naka
http://www5.ocn.ne.jp/~tomohito/TopPage.html
*/
