From a42dda2bd3cc1cf8c20cc61e7ad9211eadecbaf3 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期四, 24 二月 2022 16:55:06 +0800
Subject: [PATCH] 规范数据库，添加必要约束，优化通道批量导入功能
---
src/main/java/com/genersoft/iot/vmp/gb28181/utils/DateUtil.java | 23 ++++++++++++++++++++---
1 files changed, 20 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/genersoft/iot/vmp/gb28181/utils/DateUtil.java b/src/main/java/com/genersoft/iot/vmp/gb28181/utils/DateUtil.java
index e241bd5..604c083 100644
--- a/src/main/java/com/genersoft/iot/vmp/gb28181/utils/DateUtil.java
+++ b/src/main/java/com/genersoft/iot/vmp/gb28181/utils/DateUtil.java
@@ -2,16 +2,18 @@
import java.text.ParseException;
import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.Locale;
/**
- * @Description:鏃堕棿宸ュ叿绫伙紝涓昏澶勭悊ISO 8601鏍煎紡杞崲
- * @author: songww
+ * @description:鏃堕棿宸ュ叿绫伙紝涓昏澶勭悊ISO 8601鏍煎紡杞崲
+ * @author: swwheihei
* @date: 2020骞�5鏈�8鏃� 涓嬪崍3:24:42
*/
public class DateUtil {
- private static final String yyyy_MM_dd_T_HH_mm_ss_SSSXXX = "yyyy-MM-dd'T'HH:mm:ss.SSSXXX";
+ //private static final String yyyy_MM_dd_T_HH_mm_ss_SSSXXX = "yyyy-MM-dd'T'HH:mm:ss.SSSXXX";
+ private static final String yyyy_MM_dd_T_HH_mm_ss_SSSXXX = "yyyy-MM-dd'T'HH:mm:ss";
private static final String yyyy_MM_dd_HH_mm_ss = "yyyy-MM-dd HH:mm:ss";
public static String yyyy_MM_dd_HH_mm_ssToISO8601(String formatTime) {
@@ -37,4 +39,19 @@
}
return "";
}
+
+ public static long yyyy_MM_dd_HH_mm_ssToTimestamp(String formatTime) {
+ SimpleDateFormat format=new SimpleDateFormat(yyyy_MM_dd_HH_mm_ss);
+ //璁剧疆瑕佽鍙栫殑鏃堕棿瀛楃涓叉牸寮�
+ Date date;
+ try {
+ date = format.parse(formatTime);
+ Long timestamp=date.getTime()/1000;
+ //杞崲涓篋ate绫�
+ return timestamp;
+ } catch (ParseException e) {
+ e.printStackTrace();
+ }
+ return 0;
+ }
}
--
Gitblit v1.8.0