RE: format data in stored procedure

For the first try:Â*
Define yr = year(date_var);

For the second check out the to_char function to format the numeric. Use the concatenation operator || to tack the result to the char column.

Art

Sent from my Galaxy S®IIIjoe <joeclhua@gmail.com> wrote:I want to format data value like :
let char_var = date_var using 'yy' ; ( get the year from date )
&
let char_var2 = char_var1, int_var using '&&&&' ;
(concatenate character and integer)

These command working in 4gl program.
How can I do the same job in stored procedure ?
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list