Yes,
set SERVEROUT ON
and run following procedure

declare
x Varchar2(11);
y date;
begin
select to_char(sysdate,'dd-mon-yyyy') into x
from dual;
y :=to_date(x);
dbms_output.put_line(y);
end;

Pitamber Soni

-----------------------------


[QUOTE][i]Originally posted by kmesser [/i]
[B]Could you display the value after selecting it as a string, then process it using it as a date? For example, select to_char(sysdate, 'dd-mon-yyyy') into X from dual. Then in a subsequent line of code, use X as a date, such as Y := to_date(X);


I'll try to be more specific if you post how you are using it. For example, if it's in forms or a stored procedure . . . [/B][/QUOTE]