Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date parts
set serveroutput on
declare
v_char1 varchar2(20);
v_char2 varchar2(20);
begin
select to_char(SYSDATE,'DDDHH24MI') into v_char1 from dual;
select concat('7',v_char1) into v_char2 from dual;
dbms_output.put_line('v_char2 is '||v_char2);
end;
/
Paul in VT
Received on Thu Nov 18 1999 - 12:20:57 CST