I did the conversion in flamerobin.
Selected the table on the tables tree, opened the form and changed the attribute types.
I expected some trouble as i didn't know if there was some data in the columns, but no hassle then .

I later solved this by dropping both columns and recreating them, as there was no data expected. I guess this teaches me to **really** inspect and convert data thoroughly before touching ddl on db, even on "simple" cases like this.

Regards

Pablo

--- In firebird-support@yahoogroups.com, "roydamman" <damman@...> wrote:
>
>
>
>
> --- In firebird-support@yahoogroups.com, "pablosanchezuy" <pablos@> wrote:
> >
> > I have converted 2 attributes on table from timestamp to time format, yesterday . Engine didn't complain on that .
> >
>
> How did you do the conversion?
>