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)
2. in a DBGrid, the time is displayed after the date, (ugly)

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 ?

TIA

Duilio Foschi