Parse millis from timeString

Gleb Kartashov

Hi!

I have a Time to SLA "TTS - Duration Field" custom field which contains a "timestring" value type. I need to convert this duration to millis, but Date.parse doesn't work for me:

Message:

java.text.ParseException: Unparseable date: "2d"

 How do I convert this type of time to millis?

Tuncay Senturk _Snapbytes_

Hi @Gleb Kartashov 

@Nic Brough -Adaptavist- is right this is time string.

Considering you are using 7/24 calendar, below code might help.

Bear in mind that it returns as seconds but you can multiply by 1000 to get milliseconds.

 

import java.util.regex.Matcher;
import java.util.regex.Pattern;


Map timesAsSeconds = new HashMap<String, BigDecimal>();
timesAsSeconds.put("m", 60);
timesAsSeconds.put("h", 60 * 60);
timesAsSeconds.put("d", 24 * 60 * 60);

BigDecimal sum = new BigDecimal(0);
String duration = "3h 30m";
Matcher m = Pattern.compile("(\\d+)([d|h|m]*)").matcher(duration);
while (m.find()) {
   String type = m.group(3);
   String multiplier = m.group(2);
   BigDecimal value = timesAsSeconds.get(type);
   sum = sum.add(value.multiply(new BigDecimal(multiplier)));
}

return sum.longValue();

 

I hope it helps 

Tuncay