Subject Current_timestamp and miliseconds
Author dirknaudts

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)


Dirk Naudts.