Seems like you are using dialect 1, and if so, then no, there isn't
any better way. For dialect 3, things are a bit different and you have
a separate type called TIME.

Dialect 1:
DATE (Timestamp, i.e. date and time)

Dialect 3:
DATE (Date only)
TIME (Time only)
TIMESTAMP (=Date in Dialect 1)

Set

--- In firebird-support@yahoogroups.com, Raigo wrote:
> I need to store only time in a field. What is best data type to be
used?
>
> I tried "DATE" but when I store time I get "30.12.1899 + mytime" for
> example "30.12.1899 8:15:00"
>
> Is there a better way?
> Firebird 1.0.3.