### Question:
QueryStripper { public String getStrippedSql() { String secureQuery = new SqlSecurer(sql).getSecureSql(); Select stmt = null; try { stmt = (Select) CCJSqlParserUtil.parse(secureQuery); } catch (JSQLParserException e) { throw new RuntimeException(e); } stmt.getSelectBody().accept(new QueryStripperVisitor()); return stmt.toString(); } QueryStripper(String sql); String getStrippedSql();  }### Answer:
@Test public void stripDouble() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = 50.1234").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = 0"); }
@Test public void stripDate() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '1999-03-04'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '2000-01-01'"); }
@Test public void stripDate2() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '1999-3-4'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '2000-01-01'"); }
@Test public void stripTime() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '1:13:56'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '12:00:00'"); }
@Test public void stripTime2() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '14:13:56'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '12:00:00'"); }
@Test public void stripTimestamp() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '1999-03-04 01:13:56'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '2000-01-01 12:00:00'"); }
@Test public void stripTimestamp2() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = '1999-3-4 13:13:56.100'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = '2000-01-01 12:00:00'"); }
@Test public void stripSelectAllQuery() { String sql = new QueryStripper("SELECT * FROM Table").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\""); }
@Test public void stripInteger() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = 10").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = 0"); }
@Test public void stripString() { String sql = new QueryStripper("SELECT * FROM Table WHERE col = 'test'").getStrippedSql(); Assertions.assertEquals(sql, "SELECT * FROM \"TABLE\" WHERE \"COL\" = ''"); }