Using Node.js (Express) and mySQL to INSERT for a TIMESTAMP?

Question

Just trying to do some simple messaging here:

   var post = {
        sender_username : sender_username,
        recipient_username : recipient_username, 
        message_no : 1,
        content : content, 
        time : ***CURRENT TIMESTAMP***, 
        read : 0
    };

    connection.query('INSERT INTO message SET ?', post, function(err, result) {
        if (err) {
            res.send(err);
        }
        else {
            res.send(post); 
        }
    });

What's the simplest way to stick the date and time in there that is valid for the TIMESTAMP type?

Salar · Answer 1 · 2016-12-16T07:16:11.213

24

You can use Moment.js for this purpose:

Date.now returns current timestamp in millisecond and moment also works with milliseconds.

var mysqlTimestamp = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss');

edited Dec 16 '16 at 07:16

answered Dec 15 '16 at 10:58

Salar

5,305
7
50
78

1

Since the question is for CURRENT_TIMESTAMP, this should be marked as the correct answer – codeaddslife Dec 23 '17 at 04:53

score 4 · Accepted Answer · edited May 23 '17 at 12:24

4

The native JS way can be found in the answers here.

Personally, I use Moment.js for anything that deals with dates.

moment().utc().format('hh:mm:ss')

NOTE: I got confused with your question. You asked for "CURRENT_TIME" but your format is TIMESTAMP. MySQL's TIME and TIMESTAMP types are different. TIMESTAMP contains both the date and time and the default value function for that is "CURRENT_TIMESTAMP". I'm assuming you're referring to the TIME type.

edited May 23 '17 at 12:24

Community

1
1

answered Jun 01 '14 at 08:15

hyubs

737
6
18

I happened to already be using moment for birthdays, so this is awesome. Node.js has some great modules! (EDIT: I actually meant the TIMESTAMP type. I'll clear that up in my post.) – senjougahara Jun 01 '14 at 08:20

score 0 · Answer 3 · answered Oct 14 '18 at 09:45

0

You can use {time: new Date(GMTtimeString).toLocaleString()} where GMTtimeString sent from front-end.

answered Oct 14 '18 at 09:45

Itzhak Galitch

366
4
19

Using Node.js (Express) and mySQL to INSERT for a TIMESTAMP?

3 Answers3