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/