From ce08531ab8bdb3995b59dff19830489d547b9eb2 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Thu, 10 Jun 2021 18:09:25 -0700 Subject: add updated stamp for accounts --- routes/admin.js | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/routes/admin.js b/routes/admin.js index deb8dd3e..b2c27369 100644 --- a/routes/admin.js +++ b/routes/admin.js @@ -150,7 +150,7 @@ router.get( const {nonZero} = req.query var accounts = knex - .select('username', 'accounts.id as account_id', 'ticker', 'balance', knex.raw('LEFT(accounts.createdAt, 10) as created_at')) + .select('username', 'accounts.id as account_id', 'ticker', 'balance', knex.raw('LEFT(accounts.createdAt, 10) as created'), knex.raw('LEFT(accounts.updatedAt, 10) as updated')) .from('accounts') .leftJoin('users', 'users.id', 'accounts.user_id') -- cgit v1.2.3