RunKit + npm:

const Knex = require('knex'); const knex = Knex({ client: 'mysql' }); knex.select(knex.raw('DATEDIFF("2018-04-15", STR_TO_DATE(birthdate, "%d/%m/%Y")) / 365.25 as age')) .from('user') .orderBy('age', 'desc') .toSQL();