Sorry, forget about this one....
Just read HeLen's answer to a similar question in message 43499

I had clicked the search Archive button but only later noticed the
message saying it only searched from message x to y and offered a
next button to continue searching...


Best Regards,

Dirk Naudts.


--- In firebird-support@yahoogroups.com, "dirknaudts"
<dirk.naudts@s...> wrote:

> Hi,
>
> Doing a select current_timestamp from rdb$database
> always seems to return zero's for the miliseconds part,
> do I need to do anything to get the actual miliseconds back
> and how does this apply to a timestamp field ? I'd also like to see
> the miliseconds there ...
>
> I actually created a field like this
>
> alter table Sync_data
> add SyncTimestamp timestamp default Current_timestamp;
>
> but as said don't get any miliseconds shown here either
>
> (I've used both Isql qnd IBExpert with Grid-display formats set to
> hh:mm:ss.zzz to visualize)
>
> thanks,
>
> Dirk Naudts.