Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

[yidasanqian]

DateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss", Locale.getDefault());
String currentDate = dateFormat.format(new Date());

expressionList.getExpressions()
                        .add(new TimestampValue(currentDate ));

Exception:

Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
	at java.sql.Timestamp.valueOf(Timestamp.java:237)
	at net.sf.jsqlparser.expression.TimestampValue.<init>(TimestampValue.java:34)

[wumpz]

TimestampValue expects the value in simple quotation.

new TimestampValue("'" + currentDate + "'");

Maybe you could provide a PR to correct this and process both (with / without) possibilities.

[yidasanqian]

@wumpz
Source Code Version:1.2-SNAPSHOT

There is no such class SimpleNode

[wumpz]

SimpleNode is one of the classes generated by jjtree. You need to build it using maven. Then the missing classes will be under genereated-sources.