得到java时间戳 用于数据库中按时间戳查询数据
来源:互联网 发布:go语言 人工智能 编辑:程序博客网 时间:2024/06/07 18:28
得到java时间戳 用于数据库中按时间戳查询数据
包括:今天、昨天、本周、本月、本年、选定的时间段
package test;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class DateTest {
public static long FromYear(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.set(Calendar.MONTH,0);
return nowDate.getTimeInMillis()/1000;
}
public static long ToYear(){
Calendar nowDate= new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.set(Calendar.MONTH,12);
return nowDate.getTimeInMillis()/1000;
}
public static long FromMonth(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long ToMonth(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.add(Calendar.MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long FromWeek(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_WEEK,Calendar.MONDAY);
return nowDate.getTimeInMillis()/1000;
}
public static long ToWeek(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_WEEK,Calendar.MONDAY);
nowDate.add(Calendar.WEEK_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long FromYesterday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.add(Calendar.DAY_OF_MONTH,-1);
return nowDate.getTimeInMillis()/1000;
}
public static long ToYesterday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
return nowDate.getTimeInMillis()/1000;
}
public static long FromToday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
return nowDate.getTimeInMillis()/1000;
}
public static long ToToday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.add(Calendar.DAY_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
/**startDate 格式 2009-02-03
* startTime 格式 12:20
* */
public static long FromTime(String startDate,String startTime){
Calendar nowDate = new java.util.GregorianCalendar();
long fromtime=0;
if(!startDate.equals("")){
String []s=startDate.split("-");
nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.DAY_OF_MONTH,Integer.parseInt(s[2]));
nowDate.set(Calendar.MONTH,Integer.parseInt(s[1])-1);
nowDate.set(Calendar.YEAR,Integer.parseInt(s[0]));
String []t=startTime.split(":");
nowDate.set(Calendar.HOUR_OF_DAY,Integer.parseInt(t[0]));
nowDate.set(Calendar.MINUTE,Integer.parseInt(t[1]));
nowDate.set(Calendar.SECOND,0);
fromtime = nowDate.getTimeInMillis()/1000;
}
return fromtime;
}
/**endDate 格式 2009-02-03
* endTime 格式 12:20
* */
public static long ToTime(String endDate,String endTime){
Calendar nowDate = new java.util.GregorianCalendar();
long totime=0;
if(!endDate.equals("")){
String []s=endDate.split("-");
nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.DAY_OF_MONTH,Integer.parseInt(s[2]));
nowDate.set(Calendar.MONTH,Integer.parseInt(s[1])-1);
nowDate.set(Calendar.YEAR,Integer.parseInt(s[0]));
String []t=endTime.split(":");
nowDate.set(Calendar.HOUR_OF_DAY,Integer.parseInt(t[0]));
nowDate.set(Calendar.MINUTE,Integer.parseInt(t[1]));
nowDate.set(Calendar.SECOND,0);
totime = nowDate.getTimeInMillis()/1000;
}
return totime;
}
//格式化时间戳,参数为秒,不需要乘以1000
public static String FormatTimeStamp(String pattern, long date) {
if(pattern.length()==0)
pattern = "yyyy-MM-dd HH:mm:ss";
java.util.Calendar nowDate = new java.util.GregorianCalendar();
nowDate.setTimeInMillis(date*1000);
DateFormat df = new SimpleDateFormat(pattern);
return df.format(nowDate.getTime());
}
public static void main(String args[]){
System.out.println("今天:");
System.out.println(FormatTimeStamp("",FromToday())+"---"+FormatTimeStamp("",ToToday()));
System.out.println("昨天:");
System.out.println(FormatTimeStamp("",FromYesterday())+"---"+FormatTimeStamp("",ToYesterday()));
System.out.println("本周:");
System.out.println(FormatTimeStamp("",FromWeek())+"---"+FormatTimeStamp("",ToWeek()));
System.out.println("本月:");
System.out.println(FormatTimeStamp("",FromMonth())+"---"+FormatTimeStamp("",ToMonth()));
System.out.println("本年:");
System.out.println(FormatTimeStamp("",FromYear())+"---"+FormatTimeStamp("",ToYear()));
System.out.println("固定时间段:2008-02-28 00:00-----2009-03-31 12:22");
System.out.println(FormatTimeStamp("",FromTime("2008-02-28","00:00"))+"---"+FormatTimeStamp("",ToTime("2009-03-31","12:22")));
}
}
包括:今天、昨天、本周、本月、本年、选定的时间段
package test;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class DateTest {
public static long FromYear(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.set(Calendar.MONTH,0);
return nowDate.getTimeInMillis()/1000;
}
public static long ToYear(){
Calendar nowDate= new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.set(Calendar.MONTH,12);
return nowDate.getTimeInMillis()/1000;
}
public static long FromMonth(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long ToMonth(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_MONTH,1);
nowDate.add(Calendar.MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long FromWeek(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_WEEK,Calendar.MONDAY);
return nowDate.getTimeInMillis()/1000;
}
public static long ToWeek(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.set(Calendar.DAY_OF_WEEK,Calendar.MONDAY);
nowDate.add(Calendar.WEEK_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
public static long FromYesterday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.add(Calendar.DAY_OF_MONTH,-1);
return nowDate.getTimeInMillis()/1000;
}
public static long ToYesterday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
return nowDate.getTimeInMillis()/1000;
}
public static long FromToday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
return nowDate.getTimeInMillis()/1000;
}
public static long ToToday(){
Calendar nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.HOUR_OF_DAY,0);
nowDate.set(Calendar.MINUTE,0);
nowDate.set(Calendar.SECOND,0);
nowDate.set(Calendar.MILLISECOND,0);
nowDate.add(Calendar.DAY_OF_MONTH,1);
return nowDate.getTimeInMillis()/1000;
}
/**startDate 格式 2009-02-03
* startTime 格式 12:20
* */
public static long FromTime(String startDate,String startTime){
Calendar nowDate = new java.util.GregorianCalendar();
long fromtime=0;
if(!startDate.equals("")){
String []s=startDate.split("-");
nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.DAY_OF_MONTH,Integer.parseInt(s[2]));
nowDate.set(Calendar.MONTH,Integer.parseInt(s[1])-1);
nowDate.set(Calendar.YEAR,Integer.parseInt(s[0]));
String []t=startTime.split(":");
nowDate.set(Calendar.HOUR_OF_DAY,Integer.parseInt(t[0]));
nowDate.set(Calendar.MINUTE,Integer.parseInt(t[1]));
nowDate.set(Calendar.SECOND,0);
fromtime = nowDate.getTimeInMillis()/1000;
}
return fromtime;
}
/**endDate 格式 2009-02-03
* endTime 格式 12:20
* */
public static long ToTime(String endDate,String endTime){
Calendar nowDate = new java.util.GregorianCalendar();
long totime=0;
if(!endDate.equals("")){
String []s=endDate.split("-");
nowDate = new java.util.GregorianCalendar();
nowDate.set(Calendar.DAY_OF_MONTH,Integer.parseInt(s[2]));
nowDate.set(Calendar.MONTH,Integer.parseInt(s[1])-1);
nowDate.set(Calendar.YEAR,Integer.parseInt(s[0]));
String []t=endTime.split(":");
nowDate.set(Calendar.HOUR_OF_DAY,Integer.parseInt(t[0]));
nowDate.set(Calendar.MINUTE,Integer.parseInt(t[1]));
nowDate.set(Calendar.SECOND,0);
totime = nowDate.getTimeInMillis()/1000;
}
return totime;
}
//格式化时间戳,参数为秒,不需要乘以1000
public static String FormatTimeStamp(String pattern, long date) {
if(pattern.length()==0)
pattern = "yyyy-MM-dd HH:mm:ss";
java.util.Calendar nowDate = new java.util.GregorianCalendar();
nowDate.setTimeInMillis(date*1000);
DateFormat df = new SimpleDateFormat(pattern);
return df.format(nowDate.getTime());
}
public static void main(String args[]){
System.out.println("今天:");
System.out.println(FormatTimeStamp("",FromToday())+"---"+FormatTimeStamp("",ToToday()));
System.out.println("昨天:");
System.out.println(FormatTimeStamp("",FromYesterday())+"---"+FormatTimeStamp("",ToYesterday()));
System.out.println("本周:");
System.out.println(FormatTimeStamp("",FromWeek())+"---"+FormatTimeStamp("",ToWeek()));
System.out.println("本月:");
System.out.println(FormatTimeStamp("",FromMonth())+"---"+FormatTimeStamp("",ToMonth()));
System.out.println("本年:");
System.out.println(FormatTimeStamp("",FromYear())+"---"+FormatTimeStamp("",ToYear()));
System.out.println("固定时间段:2008-02-28 00:00-----2009-03-31 12:22");
System.out.println(FormatTimeStamp("",FromTime("2008-02-28","00:00"))+"---"+FormatTimeStamp("",ToTime("2009-03-31","12:22")));
}
}
- 得到java时间戳 用于数据库中按时间戳查询数据
- 得到java时间戳 用于数据库中按时间戳查询数据
- Android/Java仿微信按时间长短分类显示时间戳
- Android/Java仿微信按时间长短分类显示时间戳
- Android/Java仿微信按时间长短分类显示时间戳
- sql时间戳按时间进行分组
- 固定datetimepicker控件的时间值及数据库按时间查询
- 固定datetimepicker控件的时间值及数据库按时间查询
- django 按时间范围查询数据库
- Mysql数据库查询按时间递减显示
- 【mysql】mysql按时间查询没有某些时间导致数据缺失的解决方法
- MySql 按时间段查询数据方法
- MySql 按时间段查询数据方法
- MySql 按时间段查询数据方法
- Sybase按时间段查询数据
- MySql 按时间段查询数据方法
- mybatis按时间查询oracle数据
- db2按时间戳或日期条件查询
- openstack:''Client'' object has no attribute ''service_catalog''错误
- 蜂鸣器发出很低的不正常声音
- .NET进阶系列之六:应用程序的本地化及RESGEN.exe, AL.exe
- HDU 4115 Eliminate the Conflict (2-SAT判断)
- 教授“跨界”找到芯片设计新算法
- 得到java时间戳 用于数据库中按时间戳查询数据
- Python中实现多属性排序
- HDU1898:Sempr == The Best Problem Solver?
- 【道森试听】数据字典——Dave偶像
- C#语言基础心得
- Android 基于xmpp协议,smack包,openfire服务端的高仿QQ的即时通讯实现【2】创建连接,登录openfire服务端
- Install Lamp With 1 Command In Ubuntu 12.10
- Windows 7系统安装MySQL5.5.21图解 .
- android 自由操作系统数据库