Using built-in SQL functions with SequelizeJS

Question

Can I force Sequelize JS to include the combo box in the result set to get the results as for the following query?

SELECT id, NOW()-timestamp as recordAge FROM myTable

I would not use a raw query for this task, I prefer to resolve it using the model paradigm.

+3

Snark NN 19 Sep 14 at 10:45

1 answer

Snark NN · Accepted Answer · 2014-09-26T14:59:56+0000

Since there was no answer, but someone took my question down, I am posting the answer I found myself:

The solution is to use the Sequelize.literal () function . For example, in the question, the answer is:

options = {};
options.attributes = ['id', sequelize.literal('(NOW() - timestamp) as recordAge')];
MyTable.find(options).success(success);