Date Formats

KNIME Analytics Platform
6

I hope this will work:

bMWHkQPQ8r
bMWHkQPQ8r943×448 27.7 KB

Try below workflow:

Java Snippet Code:

import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

//Only work if you know what will be the format if  ".", "-", and "/" will appear.
String dotPattern = "dd.MM.yyyy HH:mm:ss";
String minusPattern = "dd-MMM-yy h:mm:ss a";
String slashPattern = "M/d/yyyy h:mm:ss a";
String outputPattern = "yyyy-MM-dd'T'HH:mm:ss";

DateTimeFormatter outputFormatter = DateTimeFormatter.ofPattern(outputPattern);

if(c_DateTime.contains("."))
{
	DateTimeFormatter inputDotFormatter = DateTimeFormatter.ofPattern(dotPattern);
    LocalDateTime localDotDateTime = LocalDateTime.parse(c_DateTime, inputDotFormatter);
    out_DateTime = localDotDateTime.format(outputFormatter);
}
else if(c_DateTime.contains("-"))
{
	DateTimeFormatter inputMinusFormatter = DateTimeFormatter.ofPattern(minusPattern);
    LocalDateTime localMinusDateTime = LocalDateTime.parse(c_DateTime, inputMinusFormatter);
    out_DateTime = localMinusDateTime.format(outputFormatter);
}
else if(c_DateTime.contains("/"))
{
	DateTimeFormatter inputSlashFormatter = DateTimeFormatter.ofPattern(slashPattern);
    LocalDateTime localSlashDateTime = LocalDateTime.parse(c_DateTime, inputSlashFormatter);
    out_DateTime = localSlashDateTime.format(outputFormatter);
}