What's the meaning of the Date d = new Date(Long.parseLong("1000000000000")); why need to use the 1000000000000 to get the 2001-09-09 date, how to caculate?and other question if i need to email reminder, that's mean i have a timesheet table and have an attribute in this table (submission_date). If the date in this attribute is late for each monday then we need to automatically to generate an email to reminder the staff to submit their timesheet. This procedure is in oracle or in jsp? i can't find any method to realise.
package com.hoten.util; import java.util.*; /** * <p>Title: Time </p> * <p>Description: </p> * 此类主要用来取得本地系统的系统时间并用下面5种格式显示 * 1. YYMMDDHH 8位 * 2. YYMMDDHHmm 10位 * 3. YYMMDDHHmmss 12位 * 4. YYYYMMDDHHmmss 14位 * 5. YYMMDDHHmmssxxx 15位 (最后的xxx 是毫秒) * <p>Copyright: Copyright (c) 2003</p> * <p>Company: hoten </p> * @author lqf * @version 1.0 */ public class Time { public static final int YYMMDDhhmmssxxx=15; public static final int YYYYMMDDhhmmss=14; public static final int YYMMDDhhmmss=12; public static final int YYMMDDhhmm=10; public static final int YYMMDDhh=8; /** * 取得本地系统的时间,时间格式由参数决定 * @param format 时间格式由常量决定 * @return String 具有format格式的字符串 */ public static String getTime(int format){ StringBuffer cTime=new StringBuffer(15); Calendar time=Calendar.getInstance(); int miltime=time.get(Calendar.MILLISECOND); int second=time.get(Calendar.SECOND); int minute=time.get(Calendar.MINUTE); int hour=time.get(Calendar.HOUR_OF_DAY); int day =time.get(Calendar.DAY_OF_MONTH); int month=time.get(Calendar.MONTH)+1; int year =time.get(Calendar.YEAR); time=null; if(format!=14){ if(year>=2000) year=year-2000; else year=year-1900; } if(format>=2){ if(format==14) cTime.append(year); else cTime.append(getFormatTime(year,2)); } if(format>=4) cTime.append(getFormatTime(month,2)); if(format>=6) cTime.append(getFormatTime(day,2)); if(format>=8) cTime.append(getFormatTime(hour,2)); if(format>=10) cTime.append(getFormatTime(minute,2)); if(format>=12) cTime.append(getFormatTime(second,2)); if(format>=15) cTime.append(getFormatTime(miltime,3)); return cTime.toString().trim(); } /** * 产生任意位的字符串 * @param time 要转换格式的时间 * @param format 转换的格式 * @return String 转换的时间 */ private static String getFormatTime(int time,int format){ StringBuffer numm=new StringBuffer(format); int length=String.valueOf(time).length(); if(format<length) return null; for(int i=0 ;i<format-length ;i++){ numm.append("0"); } numm.append(time); return numm.toString().trim(); } }
select to_char(starttime, 'yyyy/mm/dd'),
to_char(endtime, 'yyyy/mm/dd'),
……
Date(Long.parseLong("1000000000000"));
why need to use the 1000000000000 to get the 2001-09-09 date, how to caculate?and other question if i need to email reminder, that's mean i have a timesheet table and have an attribute in this table (submission_date). If the date in this attribute is late for each monday then we need to automatically to generate an email to reminder the staff to submit their timesheet. This procedure is in oracle or in jsp? i can't find any method to realise.
import java.util.*;
/**
* <p>Title: Time </p>
* <p>Description: </p>
* 此类主要用来取得本地系统的系统时间并用下面5种格式显示
* 1. YYMMDDHH 8位
* 2. YYMMDDHHmm 10位
* 3. YYMMDDHHmmss 12位
* 4. YYYYMMDDHHmmss 14位
* 5. YYMMDDHHmmssxxx 15位 (最后的xxx 是毫秒)
* <p>Copyright: Copyright (c) 2003</p>
* <p>Company: hoten </p>
* @author lqf
* @version 1.0
*/
public class Time {
public static final int YYMMDDhhmmssxxx=15;
public static final int YYYYMMDDhhmmss=14;
public static final int YYMMDDhhmmss=12;
public static final int YYMMDDhhmm=10;
public static final int YYMMDDhh=8;
/**
* 取得本地系统的时间,时间格式由参数决定
* @param format 时间格式由常量决定
* @return String 具有format格式的字符串
*/
public static String getTime(int format){
StringBuffer cTime=new StringBuffer(15);
Calendar time=Calendar.getInstance();
int miltime=time.get(Calendar.MILLISECOND);
int second=time.get(Calendar.SECOND);
int minute=time.get(Calendar.MINUTE);
int hour=time.get(Calendar.HOUR_OF_DAY);
int day =time.get(Calendar.DAY_OF_MONTH);
int month=time.get(Calendar.MONTH)+1;
int year =time.get(Calendar.YEAR);
time=null;
if(format!=14){
if(year>=2000) year=year-2000;
else year=year-1900;
}
if(format>=2){
if(format==14) cTime.append(year);
else cTime.append(getFormatTime(year,2));
}
if(format>=4)
cTime.append(getFormatTime(month,2));
if(format>=6)
cTime.append(getFormatTime(day,2));
if(format>=8)
cTime.append(getFormatTime(hour,2));
if(format>=10)
cTime.append(getFormatTime(minute,2));
if(format>=12)
cTime.append(getFormatTime(second,2));
if(format>=15)
cTime.append(getFormatTime(miltime,3));
return cTime.toString().trim();
}
/**
* 产生任意位的字符串
* @param time 要转换格式的时间
* @param format 转换的格式
* @return String 转换的时间
*/
private static String getFormatTime(int time,int format){
StringBuffer numm=new StringBuffer(format);
int length=String.valueOf(time).length(); if(format<length) return null; for(int i=0 ;i<format-length ;i++){
numm.append("0");
}
numm.append(time);
return numm.toString().trim();
}
}
date:
result.getDate("DATE")==null?"":result.getDate("DATE").toString().substring(0,10)time:
result.getDate("DATE")==null?"":result.getDate("DATE").toString().substring(10)