Hi Duilio

I use delphi x FB with dialect 1 with none of the problems you discribed.

First I format the field (display mask) to show only the date part, so in
the grid it will not be ugly.

Second I use Rx Library, I set the RxDBDateEdit to store only the date
part, so the fields are always stored as 01-01-2002 00:00:00, so when I do
compares it just works.

Try this, if you have any doubts e-mail me privately.

You can change the database dialect, I never did this, but as far i can
recall, you should use gifx to change it.

Alexandre


At 17:03 01/05/2002 +0200, you wrote:

>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
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/