//方法-轉SQL日期到JAVA(String to long)
public String timetoString(long time) {
SimpleDateFormat sf = new SimpleDateFormat("yyyyMMdd");
Date date = new Date(time);
return sf.format(date);
}
//轉JAVA long to Sql(long to Sql)
String sDt = "19910714";
SimpleDateFormat sdf= new SimpleDateFormat("yyyyMMdd");
Date dt2=null;
try {
dt2 = sdf.parse(sDt);
} catch (ParseException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
long lTime = dt2.getTime();