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);
statehooddate DATE;
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.