Create a CONVERT expression for type conversion SQL: CONVERT(value, type) for MySQL, or CAST for other dialects
// CONVERT(value, to_type)User.findAll({ attributes: [[conv(col('value'), null, 'CHAR'), 'strValue']]})// CONVERT with charset (MySQL)conv(col('name'), null, 'CHAR(255) CHARACTER SET utf8mb4')// Base type conversionconv(col('text'), 'CHAR', 'INTEGER') Copy
// CONVERT(value, to_type)User.findAll({ attributes: [[conv(col('value'), null, 'CHAR'), 'strValue']]})// CONVERT with charset (MySQL)conv(col('name'), null, 'CHAR(255) CHARACTER SET utf8mb4')// Base type conversionconv(col('text'), 'CHAR', 'INTEGER')
Create a CONVERT expression for type conversion SQL: CONVERT(value, type) for MySQL, or CAST for other dialects