add dateTimeStringToMillis to StringTools

PhilippSalvisberg · PhilippSalvisberg · commit 1749af8147c7 · 2021-01-03T10:49:19.000+01:00
diff --git a/sqldev/src/main/java/org/utplsql/sqldev/model/StringTools.java b/sqldev/src/main/java/org/utplsql/sqldev/model/StringTools.java
@@ -15,11 +15,14 @@
  */
 package org.utplsql.sqldev.model;
 
+import java.text.ParseException;
 import java.text.SimpleDateFormat;
 import java.util.Collections;
 import java.util.Date;
 import java.util.List;
 
+import org.utplsql.sqldev.exception.GenericRuntimeException;
+
 public class StringTools {
     // do not instantiate this class
     private StringTools() {
@@ -87,4 +90,17 @@ public static String getSysdate() {
         return millisToDateTimeString(System.currentTimeMillis());
     }
     
+    public static long dateTimeStringToMillis(final String dateTime) {
+        // handle milliseconds separately since they get lost (rounded) when converted to date
+        final SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss");
+        Date date;
+        try {
+            date = df.parse(dateTime.substring(0, 20));
+        } catch (ParseException e) {
+            throw new GenericRuntimeException("cannot parse datetime string " + dateTime + ".", e);
+        }
+        long millis = Long.parseLong(dateTime.substring(20, 23));
+        return date.getTime() + millis;
+    }
+    
 }
