Subject Re: changing dialect
Author andrew_s_vaz

> 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
> with little tears, sweat and blood ?
Shouldn't this be possible doing a backup and a restore (with gbak for

Just my 2 cents