alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; select sysdate from dual;
select sysdate from dual;
Date date = new Date(); SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss", Locale.US); String currTime = formatter.format(date);
通常: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';SELECT SYSDATE FROM DUAL; ORA9中,也可以: ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';SELECT CURRENT_DATE FROM DUAL;
select sysdate from dual;
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss",
Locale.US);
String currTime = formatter.format(date);
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';SELECT SYSDATE FROM DUAL;
ORA9中,也可以:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';SELECT CURRENT_DATE FROM DUAL;