Hi Simon,

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..

gives miliseconds i think, if miliseconds works.
Dimitry may be closed it by default, because there was some
complaints. ;)


Regards.
Ali

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

> Can anybody tell me the correct syntax to extract milliseconds from a
> timestamp using FB 2?
>
> rgds
>
> Si Carter
> http://www.fbtalk.net/
> http://www.tectsoft.net/