转换字符型: select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') from dual;
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') from dual;
编译有错,错误在alter处,请各位指教,谢谢 function getDatetime return varchar is Result varchar2(19); begin alter session_privs sets nls_session_parameters='yyyy-mm-dd hh:mi:ss'; select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual; return(Result); end;
抱歉贴错了,应该是下面的语句 编译有错,错误在alter处,请各位指教,谢谢 function getDatetime return varchar is Result varchar2(19); begin alter session set nls_date_format='yyyy-mm-dd hh:mi:ss'; select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual; return(Result); end;
create or replace function getDatetime return varchar is Result varchar2(19); begin select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual; return(Result); end;
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') from dual;
function getDatetime return varchar is Result varchar2(19);
begin
alter session_privs sets nls_session_parameters='yyyy-mm-dd hh:mi:ss';
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual;
return(Result);
end;
编译有错,错误在alter处,请各位指教,谢谢
function getDatetime return varchar is Result varchar2(19);
begin
alter session set nls_date_format='yyyy-mm-dd hh:mi:ss';
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual;
return(Result);
end;
return varchar is Result varchar2(19);
begin
select to_char(sysdate,'yyyy-mm-dd hh:mi:ss') into Result from dual;
return(Result);
end;