看周几有几种方法:
1、select to_char(sysdate,'D') from dual;会返回1,2,..7
2、select to_char(sysdate,'DY') from dual;会返回Mon,Tue...Sun
3、select to_char(sysdate,'DAY') from dual;会返回Monday,...Sunday
看周几有几种方法:
1、select to_char(sysdate,'D') from dual;会返回1,2,..7
2、select to_char(sysdate,'DY') from dual;会返回Mon,Tue...Sun
3、select to_char(sysdate,'DAY') from dual;会返回Monday,...Sunday
看几时方法:
1、select to_char(sysdate,'HH') from dual;会返回1,2,...12
2、select to_char(sysdate,'HH24') from dual;会返回0,1,2...24