Subject Re: Current_timestamp and miliseconds
Author dirknaudts
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, "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.