hi geoff,

The two database is in dialect 3.

thanks for your help


-- In IBObjects@yahoogroups.com, Geoff Worboys <geoff@t...> wrote:

> > The dskudf.dll is in the correct directory location (udf in
> > firebird installation directory), and the function work with
> > an other DB in the same server.
>
> Hi virux,
>
> Is it possible that the difference is in the SQL dialect of
> the databases?
>
> That is; data type DATE is actually a timestamp (64bit
> value) in dialect 1, but it is a date (32bit value) in d3.
>
> Your example from the problem database seems to indicate
> that it may be a dialect 1 database (it is showing a time
> part for the field, even if it is zero).
>
>
> --
> Geoff Worboys
> Telesis Computing