Subject Re: [firebird-support] Field with Time data
Author Martijn Tonies
> 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
Upscene Productions