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 · Accepted Answer · 2016-12-16 07:16:11Z

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, 2016 at 7:16

answered Dec 15, 2016 at 10:58

Salar

5,5797 gold badges57 silver badges91 bronze badges

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

1 Comment

codeaddslife Over a year ago

Since the question is for CURRENT_TIMESTAMP, this should be marked as the correct answer

Community · Accepted Answer · 2017-05-23 12:24:55Z

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, 2017 at 12:24

CommunityBot

11 silver badge

answered Jun 1, 2014 at 8:15

hyubs

7377 silver badges18 bronze badges

1 Comment

senjougahara Over a year ago

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.)

Itzhak Galitch · Accepted Answer · 2018-10-14 09:45:49Z

0

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

answered Oct 14, 2018 at 9:45

Itzhak Galitch

3764 silver badges19 bronze badges

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related