> 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.

Dialect 3, use datatype TIME.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com