Limit date format in node.js

Question

I'm using Node.js together with mysql, express and html.

When I'm retrieving the results from the database I get the following date, 2016-03-16T00:00:00.000Z, even though the type in mysql is date.

My query:

app.get('/list', function  (req,res) {
    connection.query('SELECT `ondate`,`projectname`,`hours` FROM `entries` WHERE YEARWEEK(`ondate`, 1) = YEARWEEK(CURDATE(), 1) ORDER BY ondate DESC ,projectname ASC ', function(err, rows, fields) {  
    res.json({error: err, result: rows});
    });
})

Is there a way I can set the ondate field to ignore the time?

Which mysql driver are you using ?

user6068334
– user6068334

2016-03-19 23:04:14 +00:00
Commented Mar 19, 2016 at 23:04 — user6068334
– user6068334, Commented Mar 19, 2016 at 23:04

White Feather · Accepted Answer · 2016-03-19 23:09:55Z

3

Use this:

SELECT
DATE_FORMAT(`ondate`,'%m-%d-%Y'),
`projectname`,
`hours` 
FROM `entries` 
WHERE YEARWEEK(`ondate`, 1) = YEARWEEK(CURDATE(), 1)
ORDER BY ondate DESC, projectname ASC;

Adjust the date format to the one you need.

Regards

answered Mar 19, 2016 at 23:09

White Feather

2,7931 gold badge17 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Gulbrandsen Over a year ago

Excellent! This is what I needed

Billy Moon · Accepted Answer · 2016-03-19 23:09:16Z

2

Hard to know exactly where the unwanted formatting is being introduced, but it might be an option to remove it as part of post processing rows...

// Assuming array of rows takes shape something like this...
var rows = [{ondate:'2012-01-02T00:00:00.000Z'},{ondate:'2013-01-02T00:00:00.000Z'},{ondate:'2012-03-02T00:00:00.000Z'}];

// map rows to show only first ten chars of `ondate` field
rows = rows.map(function(item){ return item.ondate.slice(0,10); });

// business as usual...
alert(rows);
//-> 2012-01-02,2013-01-02,2012-03-02

answered Mar 19, 2016 at 23:09

Billy Moon

58.9k27 gold badges148 silver badges244 bronze badges

Collectives™ on Stack Overflow

Limit date format in node.js

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related