Re: Formating output in functions in PL/SQL

>JINGYAN WROTE:

Hi,
> I need to create two functions, each called PRINT_IT to print a date, or a
>number value depending on how the function was invoked.
>
> 1. To print the date value, use “DD_MON_YY” as the input format, and
>‘FmMonth/dd/yyyy” as the output format. Make sure you handle invalid
input.
> 2. To print the number, use “999,999.00” as the output format.
>But I don't know how to format them. Please help me! I have tried several
>ways, no one works. Thank you a lot.
>Best Regards,
>Jingyan
>/*****************

Hi
Try to_char(vnum,'999,999.90');

     to_char(vdate,'FmMonth/dd/yyyy');
hth
sandy Received on Sat Mar 18 2000 - 21:56:01 CST