Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd"); String formatDate = sdf.format(date); System.out.println(formatDate.substring(5));
--如果是字符串,直接substr截取 select substr(字段,6,2) from dual; --取得月份 select substr(字段,1,10) from dual; --取得年月日--如果是date型的 select to_char(字段,'yyyy') from dual; --取得四位的年 select to_char(字段,'mm') from dual; --取得月份 select to_char(字段,'dd') from dual; --取得天 select to_char(字段,'hh24') from dual; --取得时 select to_char(字段,'mi') from dual; --取得分 select to_char(字段,'ss') from dual; --取得秒
如果我要写一个sql语句不论年份 只得到在7/20和8/20之间的数据 该怎么写
--字段是字符型的,格式如:2011/07/20 00:00:00 select * from table where substr(字段,6,5) between '07/20' and '08/20';--字段是date型的 select * from table where to_char(字段,'mm/dd') between '07/20' and '08/20';
--use oracle built-in functionextract(YEAR FROM DATE '2003-08-22') --would return 2003 extract(MONTH FROM DATE '2003-08-22') --would return 8 extract(DAY FROM DATE '2003-08-22') --would return 22
这个 SELECT * FROM IDL_EX_BATCH T WHERE TO_NUMBER(TO_CHAR(T.UPDATED_DATE, 'MMDD')) BETWEEN 720 AND 820
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");
String formatDate = sdf.format(date);
System.out.println(formatDate.substring(5));
--如果是字符串,直接substr截取
select substr(字段,6,2) from dual; --取得月份
select substr(字段,1,10) from dual; --取得年月日--如果是date型的
select to_char(字段,'yyyy') from dual; --取得四位的年
select to_char(字段,'mm') from dual; --取得月份
select to_char(字段,'dd') from dual; --取得天
select to_char(字段,'hh24') from dual; --取得时
select to_char(字段,'mi') from dual; --取得分
select to_char(字段,'ss') from dual; --取得秒
--字段是字符型的,格式如:2011/07/20 00:00:00
select * from table where substr(字段,6,5) between '07/20' and '08/20';--字段是date型的
select * from table where to_char(字段,'mm/dd') between '07/20' and '08/20';
--use oracle built-in functionextract(YEAR FROM DATE '2003-08-22') --would return 2003
extract(MONTH FROM DATE '2003-08-22') --would return 8
extract(DAY FROM DATE '2003-08-22') --would return 22
SELECT *
FROM IDL_EX_BATCH T
WHERE TO_NUMBER(TO_CHAR(T.UPDATED_DATE, 'MMDD')) BETWEEN 720 AND 820