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 [email protected], "roydamman" <damman@...> wrote:
>
>
>
>
> --- In [email protected], "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?
>
