db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From TomohitoNakayama <tomon...@basil.ocn.ne.jp>
Subject Question around DAY function in Derby Reference manual
Date Sun, 11 Feb 2007 06:12:27 GMT

Through translation of Derby Reference manual, I found question around
description of DAY function.

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



View raw message