Hi,


En la db del ejemplo
http://sourceforge.net/mailarchive/message.php?msg_id=23092682

The messages table has several timestamp fields, but the field
(expired) is generating
the error.

Database: cabrweb.fdb, User: sysdba
SQL> select expired from messages;

EXPIRED
=========================
2009-09-10 19:26:24.7296
2009-09-06* 36:46:12.6240*
2009-09-30 *37:45:23.1696*

Time values are out of range. Something fast could leave at zero (0) time

SQL> *update messages set expired = cast(expired as date);*
SQL> select expired from messages;

EXPIRED
=========================
2009-09-10 00:00:00.0000
2009-09-06 00:00:00.0000
2009-09-30 00:00:00.0000

Regards.

-Christian-


[Non-text portions of this message have been removed]