Subject Re: Order by error in FB 1.5
Author Adam
--- In, "jesus_cointec"
<jesus_cointec@...> wrote:
> And what about date and timestamp error with dialect 1?

In Dialect 1, the DATE datatype stores both the date and the time.

For example:

'27 Sep 2006 9:15:00 am'

In Dialect 3, the DATE datatype stores only the date.

For example:

'27 Sep 2006'

There is a new TIMESTAMP datatype that behaves like the Dialect 1 DATE

So all the fields you expect to hold both date and time should be
changed to TIMESTAMP under dialect 3. Fields that do not require the
time component should be defined as a DATE.