>>>> âÌÉÎ ÓÎÏ×Á ÉÚÏÂÒÅÔÁÅÍ ×ÅÌÏÓÉÐÅÄ ÅÓÔØ Õ ÍÅÎÑ ÆÕÎËÃÉÑ ÄÌÑ ÕÄÏÂÓÔ×Á
>>>> ÎÁÐÉÓÁÎÁÑ ÎÁÐÉÓÁÌ ËÒÁÓÉ×ÕÀ ÓÔÒÏËÕ É ÓÅÒ×ÁË ÕÐÁÌ, Á ÇÄÅ ÓÏÏÂÝÅÎÉÅ, Á
>>>> ÎÅÔÕ ÐÒÏÓÔÏ ÐÁÄÅÅÍ É ×ÓÅ ÄÁ×ÁÊ ËÏÐÁÔØ É ÎÁÒÙÌ ÓÅÒ×ÁË ÎÁÄÕÈ ÎÅ ÐÅÒÅÎÏÓÉÔ
>>>> ÄÁÔÕ ÍÅÎÅÅ 01/01/0001
>>>
>>> ôÒÙÎÄÉÛØ, ËÁË ÏÂÙÞÎÏ :
>>>
>>> Á)
>>> SELECT CAST('1.1.0001' AS DATE) - 1 FROM RDB$DATABASE
>>>
>>> expression evaluation not supported.
>>> value exceeds the range for valid dates.
>>
>> îÕ ÔÙÔÏ ÔÕÔ ÞÔÏ ÌÁÐÏÞÅÛØ :).
>
> éÍÅÀ ÐÒÁ×Ï
>
>> ôÅÂÅ ÅÝÅ ÎÉ ËÔÏ ÐÒÉÍÅÒÁ ÎÅ ÄÁÌ, Á ×ÙÓËÁÚÁÌÉÓØ ÐÒÏ ÔÏ, ÞÔÏ ÈÏÔÅÌÏÓØ ÂÙ.
>
> ôÏÇÄÁ ÎÅÈ ×ÙÓËÁÚÙ×ÁÔØÓÑ ÂÅÚ ÐÒÉÍÅÒÏ×. ïÓÏÂÅÎÎÏ Ï "ÐÁÄÅÎÉÑÈ"
>
>> îÅ ÎÁÄÏ ÄÕÍÁÓÔØ ÞÔÏ ×ÓÅ ÓÒÁÚÕ ÓÍÏÇÕÔ × ÓÔÕÄÉÀ.
>> ÷ÏÔ ÔÅÐÅÒØ ÒÅÐÏÒÔÕÀ, ÇÏÎÑÊ ÓÅÒ×ÁË ÞÔÏ ÎÅ ÐÁÄÁÌ
>>
>> select
>> B_FormatDate('ÓÔÁÖ ÌÅÔ yyyy ÍÅÓ mm ÄÎÅÊ dd',
>> b_Int64ToDate(10000*60*60*24))
>> from d001
>>
>> ECLARE EXTERNAL FUNCTION B_Int64ToDate numeric(18,0)
>> RETURNS TIMESTAMP FREE_IT ENTRY_POINT 'fn_Int64ToDate' MODULE_NAME
>> 'B_UDF285.DLL'
>>
>> ECLARE EXTERNAL FUNCTION B_FormatDate CSTRING(250), TIMESTAMP
>> RETURNS CSTRING(250) ENTRY_POINT 'fn_FormatDate' MODULE_NAME
>> 'B_UDF285.DLL'
>>
>> ÕÄÆ ÎÁ www.sayan.ru\~bolt\dy
>>
>> ÐÁÄÁÅÔ Ó ÚÁÐÉÓØÀ × ÌÏÇÅ
>> CPE4 (Server) Tue Oct 02 16:26:39 2007
>> The user defined function: B_FORMATDATE
>> referencing entrypoint: fn_FormatDate
>> in module: B_UDF285.DLL
>> caused the fatal exception: An exception occurred that does
>> not have a description. Exception number EEDFADE.
>> This exception will cause the Firebird server
>> to terminate abnormally.
>
> ëÒÉ×ÕÝÁÑ UDF - ÎÅ ÕÍÅÅÔ ÏÂÒÁÂÁÔÙ×ÁÔØ VCL-ÎÙÅ ÉÓËÌÀÞÅÎÉÑ. ðÒÉ Þ£Í ÔÕÔ FB
> ?
á ÐÒÉÔÏÍ
select b_Int64ToDate(10000*60*60*24) from rdb$database
×ÏÚ×ÒÁÝÁÅÔ
expression evaluation not supported.
value exceeds the range for valid dates.
ÚÎÁÞÉÔ É
select
B_FormatDate('ÓÔÁÖ ÌÅÔ yyyy ÍÅÓ mm ÄÎÅÊ dd', b_Int64ToDate(10000*60*60*24))
from rdb$database
ÔÏÖÅ ÄÏÌÖÎÏ ×ÅÒÎÕÔØ ÔÁËÏÅ ÓÏÏÂÝÅÎÉÅ ÎÏ ÓÅÒ×ÁË ÕÐÏÒÎÏ ÐÁÄÁÅÔ
