How to write time in mysql from nodejs?

Question

MySQL

Nodejs has a variable in the form of number of milliseconds (since 70...). How to convert this time for writing in a timestamp field in mysql?

Answer 1

new Date(timestamp).toISOString()
will return a string in the unified international ISO format
such a string can be inserted into any MySQL fields whose data type is time

Answer 2

Another option is to use the MySQL FROM_UNIXTIME function. Just remember that in javascript in milliseconds, and the function takes an argument in seconds.