对于这个我用SQL语句,在检索出来时在数据库中进行转换不知可以吗??? 例如: string date sql="select to_char( field_name ,"yyyy") as date from table_name "; rs=st.executeQuery(sql); rs.next(); date=rs.getString("date"); 行吗?
Date time = new Date(System.currentTimeMillis()); Calendar calendar = Calendar.getInstance(); calendar.setTime(time); String Year = Integer.toString(calendar.get(calendar.YEAR)); String Month = Integer.toString(calendar.get(calendar.MONTH)+1); String Day = Integer.toString(calendar.get(calendar.DATE)); String Hour = Integer.toString(calendar.get(calendar.HOUR_OF_DAY)); String Minute = Integer.toString(calendar.get(calendar.MINUTE));然后你自己用Year.substring(i,i)什么的
java 中能定义:date类型吗? 我的目的是取日期型数据的年度值,用: string date sql="select to_char( field_name ,"yyyy") as date from table_name "; rs=st.executeQuery(sql); rs.next(); date=rs.getString("date"); 这个做不行吗?
例如:
string date
sql="select to_char( field_name ,"yyyy") as date from table_name ";
rs=st.executeQuery(sql);
rs.next();
date=rs.getString("date");
行吗?
Calendar calendar = Calendar.getInstance();
calendar.setTime(time);
String Year = Integer.toString(calendar.get(calendar.YEAR));
String Month = Integer.toString(calendar.get(calendar.MONTH)+1);
String Day = Integer.toString(calendar.get(calendar.DATE));
String Hour = Integer.toString(calendar.get(calendar.HOUR_OF_DAY));
String Minute = Integer.toString(calendar.get(calendar.MINUTE));然后你自己用Year.substring(i,i)什么的
我的目的是取日期型数据的年度值,用:
string date
sql="select to_char( field_name ,"yyyy") as date from table_name ";
rs=st.executeQuery(sql);
rs.next();
date=rs.getString("date");
这个做不行吗?