@Override
    public String serialize(String literal, int jdbcType) {
        switch (jdbcType) {
            case Types.TIMESTAMP:
            case TIMESTAMP_WITH_TIMEZONE:
                return "timestamp '" + literal + "'";
            case Types.DATE:
                return "date '" + literal + "'";
            case Types.TIME:
            case TIME_WITH_TIMEZONE:
                return "timestamp '1970-01-01 " + literal + "'";
            default:
                return super.serialize(literal, jdbcType);
        }
    }
{@code OracleTemplates} is an SQL dialect for Oracle

<p>tested with Oracle 10g XE</p>

@author tiwe
querydsl-sql/src/main/java/com/querydsl/sql/OracleTemplates.java