1.String转NUMBER
Long num=Long.valueOf(str); Integer num=Integer.valueOf(str);……
2.BigDecimal转NUMBER型
Long num = str.longValue();
……
3.Timestamp转Date存 Oracle
对应实体类:
@Column(name = "GLASS_START_TIME") @Temporal(TemporalType.TIMESTAMP)
public Date getGlassStartTime() { return glassStartTime; } 对应Java操作:(java.util.Date类)
Date procEndTime = new Date(glass.getProcEndTime().getTime()); glassEntity.setGlassStartTime(procEndTime); 4.TIMESTAMP计算
Timestamp time1=etlConfD.getRunStartTimestamp(); Calendar cal = Calendar.getInstance(); cal.setTime(time1); cal.add(Calendar.MINUTE, 30);//加30分钟 Timestamp time2 = new Timestamp(cal.getTime().getTime());
4.Timestamp相减得到时间差
Date date1 = glass.getProcEndTime();//先转化成DATE型 Date date2 = glass.getProcStartTime(); Long num=date1.getTime() - date2.getTime();