Thank you Svein and Walter. It's this CAST() function which combines
date column to character column to be one column and now I'm using
UDF for more complicated combinations. It gives no problem so far.

Regards,
Mr. Hoh


--- In firebird-support@yahoogroups.com, "Svein Erling"
<svein.erling.tysvaer@k...> wrote:

> What do you mean by "combine"? <DateColumn> + <number> does make

sense

> if you want to add a certain number of days to a date, but

otherwise

> it does not make any sense to "combine" anything with a date.
>
> I suspect you want to treat the dates as something other than a

date.

> If so, you must explicitly cast the date to whatever type you

want, e.

> g.
>
> SELECT 'Mr. Hoh ' || cast(TODAY as CHAR(10))
> FROM RDB$DATABASE
>
> HTH,
> Set
>
> --- In firebird-support@yahoogroups.com, "cyhoh" <cyhoh@y...>

wrote:

> > Hi,
> > I want to select/show a column which combines two date (or time

or

> > timestamp) columns but FireBird 1.5 RC5 complains

about "arithmetic

> > exception, numeric overflow, or string truncation" and

this "select"

> > statement fails. Can anyone help me? Thanks!
> >
> > Regards,
> > Mr. Hoh