"A certain coworker of mine likes to do everything in SQL," Christoffer Hoel writes, "and I mean everything."

"Of course, since our management is non-technical, there's very little any of us can do aside from just toletarting the code. After all, his code runs about the same as ours... and that's all that matters, right?"

// Check if date is valid!
String allowed = "not allowed";

sql = "SELECT IF(DATE(?) <= DATE(?),'allowed','not allowed')";
stmt = con.prepareStatement(sql);
stmt.setString(1, firstDate);
stmt.setString(2, terminationDate);
rs = stmt.executeQuery();

while(rs.next()){
    allowed = rs.getString(1);
}
rs.close();
stmt.close();

if(!allowed.equalsIgnoreCase("allowed")){
    throw new Exception("Termination Date to early!");
}
[Advertisement] BuildMaster allows you to create a self-service release management platform that allows different teams to manage their applications. Explore how!