private BigDecimal timeformat(String time)throws ParseException{
SimpleDateFormat formatter = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss");
Date date = formatter.parse(time);
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd.HHmmss");
BigDecimal timeStamp = new BigDecimal(sdf.format(date));
return timeStamp;
}