package com.xinan.dataservice.util;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
/**
* <ol>
* date:2021-04-13 editor:songquan
* <li>获取当前时间的前某时段渐渐,后某时段时间</li>
* <li></li>
* </ol>
*
* @author <a href="mailto:3099754834@qq.com">songquan</a>
* @version 1.0
* @since 1.0
*/
public class TimeUtil {
/**
* @param args
*/
public static void main(String[] args) throws ParseException {
// TODO Auto-generated method stub
String date1 = "2009-03-23 08:00:00";//指定时间
String date2= addDate(date1,1);//加1小时方法
System.out.println("after:"+date2);
gettime("2021-05-19 10:57:42");
}
public static String addDate(String day, int x)
{
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//24小时制
//SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");//12小时制
Date date = null;
try
{
date = format.parse(day);
}
catch (Exception ex)
{
ex.printStackTrace();
}
if (date == null) return "";
Calendar cal = Calendar.getInstance();
cal.setTime(date);
cal.add(Calendar.HOUR_OF_DAY, x);//24小时制
//cal.add(Calendar.HOUR, x);12小时制
date = cal.getTime();
System.out.println("front:" + date);
cal = null;
return format.format(date);
}
public static Long gettime(String date) throws ParseException {
ArrayList<String> cons = new ArrayList<>();
cons.add("2020-04-26 08:16:38");
cons.add("2020-04-26 08:16:38");
cons.add("ZZS8316");
cons.add("460110106182218");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
long time = sdf.parse(date).getTime();
String selectSql = "select distinct imsi as imsi from gsmdata where time >=" + sdf.parse(cons.get(0)).getTime() / 1000 + "s and time <=" + sdf.parse(cons.get(1)).getTime() / 1000 + ".999999999s and ip='" + cons.get(2) + "' and imsi='" + cons.get(3) + "' tz('Asia/Shanghai') ";
// System.out.println("date: "+date2);
// System.out.println("date.toString: "+date2.toString());
// System.out.println("dateFormat: "+dateFormat);
System.out.println("dateFormatParse "+time);
System.out.println(selectSql);
return time;
}
}
获取某时间的当前之后时间
最新推荐文章于 2023-06-15 16:16:58 发布
关键词由CSDN通过智能技术生成