I'm a new student, and dont know if its ok to be posting here or not, so tell me right off what/where is appropriate for me.
That being said, I'm trying to get rid of the trailing spaces that I get when do a TO_CHAR in a PL/SQL program. Here it is for all to check out and if you can get back to me with the correct way to go about it: DECLARE
state varchar2 (20);
state := 'Wyoming';
statehooddate := TO_DATE('07/10/1890', 'MM/DD/YYYY');
statehooddate := RTRIM(statehooddate);
DBMS_OUTPUT.PUT_LINE(state || ' became a state on ' ||
TO_CHAR(statehooddate, 'Month DD, YYYY')||'.');
Wyoming became a state on July 10, 1890. As you can see the padded area is after "July", and I want to know how to remove them. I've toyed with Instr and Substr with no luck either, but I'm sure somebody here can help me with this.
Click Here to Expand Forum to Full Width