| Subject | Re: How to select date or time columns into one column? |
|---|---|
| Author | Svein Erling |
| Post date | 2003-10-29T09:01:14Z |
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
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