Dulio,

> I have a database that was built using dialect 1.
>
> Fields TIMESTAMP are giving me the following headaches:
>
> 1. I cannot exactly compare 2 timestamp fields (no small problem)

Do a cast to a date on the needed field. This should do the trick.

> 2. in a DBGrid, the time is displayed after the date, (ugly)

Use the DisplayMask property of the field. Try something
like "dd/mm/yy" .

>
> Is there a workaround ?
>
> Or is it possible to switch to dialect 3 (and the much wanted DATE

fields)

> with little tears, sweat and blood ?

Shouldn't this be possible doing a backup and a restore (with gbak for
example?)

Just my 2 cents
HTH
Andrew