Yup, you are right, it should be there.
But we can be contented with some function acrobatics until
Dimitry add it with some click. ;)
As you know milliseconds support is new in FB2 and it is still in
alpha stage.

Regards.

Ali

--- In firebird-support@yahoogroups.com, "Simon Carter"
<simon.carter@t...> wrote:

> Cheers Ali,
>
> > -----Original Message-----
> > select
> > substring(cast(cast('NOW' as timestamp) as VARCHAR(32)) from
> > 1 for 25) from rdb$database -- gives full data
> >
> > and
> >
> > .. from 21 for 3..
>
> I take it there's no
>
> EXTRACT(MILLISECONDS FROM TIMESTAMP) ;
>
> Way of doing it?
>
> Rgds
>
> Si
> http://www.tectsoft.net/
> http://www.fbtalk.net/