PaulJB wrote:

> DateDiff( year, '1973-12-01', '2005-10-20' ) возвращает 32, хотя, по
> идее, должна вернуть 31. Ведь год относительно 1973-12-01 еще не завершен.

RTFM.

---------------------------------------------------------------
What's New in SQL Anywhere Studio
What's New in Version 6.0.3
Behavior changes in version 6.0.3

Adaptive Server Anywhere behavior changes

datediff, MONTHS, and YEARS functions The number of months between
two dates is now calculated as the number of first-of-the-months between
the dates. For example, the difference between January 25 and February 2
is 1; the difference between January 1 and January 31 is 0. The number
of years is now calculated as the number of first-of-the-years between
the dates.

This changes the results of these functions by one number, in some
cases. The change was made for compatibility with Adaptive Server
Enterprise.
---------------------------------------------------------------
Posted via ActualForum NNTP Server 1.3

vooo wrote:

> Тогда сорри - все вышесказанное относилось к ASE

Неважно - оно теперь compatible :).
Posted via ActualForum NNTP Server 1.3

PaulJB wrote:

> Хм. Я не думал, что к описанию ф-ции дополнительно надо изучать еще и
> все Behavior changes ...

Открою страшную тайну : я ничего не изучал, я сделал поиск по
DATEDIFF, ткнул в первый пункт из списка и, как выяснилось, угадал.
Posted via ActualForum NNTP Server 1.3