Subject Re: Field with Time data
Author Svein Erling Tysvær
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)


--- In, Raigo wrote:
> I need to store only time in a field. What is best data type to be
> 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.