Monday 10 April 2017

Node date(timestamp) still returns time

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

No comments:

Post a Comment