Subject Extracting Time
Author Alan McDonald
I have a Firebird dialect 3 db with TIMESTAMP fields.

I need to get just the time from these fields. I actually want to format the
date part of the field separately and concatenate it badk with the time part
of the field.
F_STRIPTIME returns a date (as expected) but F_STRIPTIME also returns a DATE
(being the time cast as a date it appears and therefore 31.12.1899).

How do I get just the time from this field type - I've also tried many cast
attempts with no success other than truncation errors

PS A separate TIME field has milliseconds which I do not want either