in src/main/java/com/datacompare/service/FetchMetadata.java [408:423]
public String convertDateToTimeStamp(String colName) {
String colNameTmp = colName;
if (colNameTmp != null) {
String cols[] = colNameTmp.replace(")", "").split(",");
for (int i = 0; i < cols.length; i++) {
if (tableMetadataMap != null && tableMetadataMap.get(cols[i]) != null) {
String colType = tableMetadataMap.get(cols[i]).getColumnType();
if (colType != null && (colType.contains("DATE") || colType.contains("date") || colType.contains("TIMESTAMP") || colType.contains("timestamp"))) {
colName=colName.replace(cols[i], "TO_CHAR(" + cols[i] + ", \'YYYY-MM-DD HH24:MI:SS\')");
}
}
}
}
return colName;
}