Hi,

> I have got a problem using the new COALESCE feature.
> I use it in the following way:
>
> SELECT FIRST 10
> V.Z_Type,
> COALESCE(Z_Date, 'not defined') AS Pol
> ...
>
> Z_Date is a DATE column.
>
> The problem is that the date is displayed as 'YYYY-MM-DD',
> while my preferred setting is 'DD.MM.YYYY'.
> When I just select the Z_Date column without using COALESCE,
> the dates display correctly.
>
> I guess that the date is converted to a different type (varchar?)
> by COALESCE, so that my client (IBO) does not know how to format
> the date.
>
> Does anybody know what's going on?
> Of course, I would be glad about a small workaround ;-)

Well, I guess IBO is creating a text-column. Not a date-one.
This makes sense - how would you format a date that says
'not defined'

If you want to format the date to your particular displayformat,
you have to do it yourself.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com