add(Ops.DateTimeOps.TRUNC_SECOND, "str_to_date(date_format({0},'%Y-%m-%d %k:%i:%s'),'%Y-%m-%d %k:%i:%s')"); addTypeNameToCode("bool", Types.BIT, true); addTypeNameToCode("tinyint unsigned", Types.TINYINT); addTypeNameToCode("bigint unsigned", Types.BIGINT); addTypeNameToCode("long varbinary", Types.LONGVARBINARY, true); addTypeNameToCode("mediumblob", Types.LONGVARBINARY); addTypeNameToCode("longblob", Types.LONGVARBINARY); addTypeNameToCode("blob", Types.LONGVARBINARY); addTypeNameToCode("tinyblob", Types.LONGVARBINARY); addTypeNameToCode("long varchar", Types.LONGVARCHAR, true); addTypeNameToCode("mediumtext", Types.LONGVARCHAR); addTypeNameToCode("longtext", Types.LONGVARCHAR); addTypeNameToCode("text", Types.LONGVARCHAR); addTypeNameToCode("tinytext", Types.LONGVARCHAR); addTypeNameToCode("integer unsigned", Types.INTEGER); addTypeNameToCode("int", Types.INTEGER); addTypeNameToCode("int unsigned", Types.INTEGER); addTypeNameToCode("mediumint", Types.INTEGER); addTypeNameToCode("mediumint unsigned", Types.INTEGER); addTypeNameToCode("smallint unsigned", Types.SMALLINT); addTypeNameToCode("float", Types.REAL, true); addTypeNameToCode("double precision", Types.DOUBLE, true); addTypeNameToCode("real", Types.DOUBLE); addTypeNameToCode("enum", Types.VARCHAR); addTypeNameToCode("set", Types.VARCHAR); addTypeNameToCode("datetime", Types.TIMESTAMP, true);