Anyone know how to convert and integer value to character (without call a C
program)? In a stored procedure the below query is failing with
"-1213 A character to numeric conversion process failed." on the MonthYear
variable.
SELECT SUBSTRING(exprtext FROM 19 for 5),
SUBSTRING(exprtext FROM 48 for 5),
dbspace,
SUBSTRING(dbspace FROM 1 for 4),
MONTH(CURRENT)||YEAR(CURRENT),
CASE
WHEN MONTH(CURRENT) IN (1,3,5,7,8,10,12)
THEN "31"
WHEN MONTH(CURRENT) IN (4,6,9,11)
THEN "30"
ELSE
"29"
END
INTO LessThanDateInt, --INT
GreaterThanDateInt, --INT
DBSpaceName, --CHAR
DBSpaceDevice, --INT
MonthYear, --CHAR
DaysInMonth --CHAR
FROM sales_tran_frags
Where DATE(TRUNC(SUBSTRING(exprtext FROM 19 for 5)))
in (
select MIN(DATE(TRUNC(SUBSTRING(exprtext FROM 19 for 5))))
from sales_tran_frags
);
Thanks for any help.
Mark