I am trying to format timestamp so it only return year-dd-mm. I formated like this date(u.registered). In psql I tested it does return date format but in the server side it still returns timestamp format
db.get_mypage
select u.user_id, b.book_id, u.username, b.title, b.pages, date(u.registered)
from mypage as m
join users u on u.user_id = m.user_id
join book b on b.book_id = m.book_id
where u.user_id = $1;
node.js
app.get('/mypage/:id', function(req, res, next) {
db.get_mypage([req.params.id], function(err, individual) {
if(err) res.status(500).send(err);
else res.send(individual);
})
})
via Yh1234