> In all cases the time literals (with a blank between the date part

and the time part) is

> 'HH:MM:SS.nnn' where nnn is milliseconds.

so this is the required format?

This means that HH:MM:SS is not correct?

> In Dialect 3 you also have to cast the date literals, e.g.
>
> CAST ('19/07/2001 14:47:20.000' AS TIMESTAMP)
>
> CAST ('19/07/2001' AS DATE)
>
> CAST ('14:47:20.000' AS TIME)

Why do we need to use CAST ? How does Firebird converts the date or
time then when we don't use cast?

> cheers,
> Helen

Thanks for all your great help!

Tom.