1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') as sysday from dual;
SYSDAY
-------------------
2013-07-31 09:10:43
select to_char(sysdate(), 'yyyy-mm-dd hh24:mi:ss') as sysday from dual;
-- ORA-00907: missing right parenthesis
declare
v$_sysday varchar2(19);
begin
select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') into v$_sysday from dual;
dbms_output.put_line('Sysdate : ' || v$_sysday);
select to_char(sysdate(), 'yyyy-mm-dd hh24:mi:ss') into v$_sysday from dual;
dbms_output.put_line('Sysdate() : ' || v$_sysday);
end;
/
Sysdate : 2013-07-31 09:11:25
Sysdate() : 2013-07-31 09:11:25
Statement processed. |
Partager