Re: � ����������� �� �������� ������� ������ � ������?

[Alexey Abramov]

"áÎÄÒ¦Ê öÕË" <[EMAIL PROTECTED]> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × 
ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
>
> áÇÁ, ×ÍÅÓÔÏ GETLASTMONTHDAY(D) Ó ÌÅÆÔ ÄÖÏÊÎÏÍ ÐÉÓÁÔØ
> (D - EXTRACT(DAY FROM D) + 32 - EXTRACT(DAY FROM D - EXTRACT(DAY FROM D) + 
> 32))

^^^^^^^^^^^^^^^^^^^^^^^^^ ÎÉÁÓÉÌÉÌ (( ÎÏ ÓÍÙÓÌ ÐÏÎÑÔÅÎ

ÔÏÖÅ ÐÏÌØÚÕÀÓØ, ÔÏÌØËÏ FIRSTDAYMONTH ÉÚ rfunc.dll

ÒÁÄÉ ÐÒÉËÏÌÁ ÐÒÅÄÌÏÖÕ ÔÁËÏÊ ÉÚ×ÒÁÔ, ËÁË ÁÌØÔÅÒÎÁÔÉ×Õ
cast((EXTRACT(month FROM D) + 1)||'-01' as date) - 1


×ÓÅ 3 ÚÁÐÒÏÓÁ - ÒÁÂÏÞÉÅ ÅÓÓÎÏ:

select (current_date - EXTRACT(DAY FROM current_date) + 32 - EXTRACT(DAY 
FROM current_date - EXTRACT(DAY FROM current_date) + 32))
from RDB$DATABASE

select cast(EXTRACT(year FROM current_date)||'-'||(EXTRACT(month FROM 
current_date) + 1)||'-01' as date) - 1
from RDB$DATABASE

select cast((EXTRACT(month FROM current_date) + 1)||'-01' as date) - 1
from RDB$DATABASE


ó Õ×ÁÖÅÎÉÅÍ
áÌÅËÓÅÊ áÂÒÁÍÏ×