날짜 및 시간비교

1. Moment.js 브라우저나 환경에따라서 다르게 작동되는 시간의 형태를 통합

http://momentjs.com/

2. 마이크로소프트에서 제공하는 팁

https://docs.microsoft.com/ko-kr/scripting/javascript/calculating-dates-and-times-javascript

---

시간의 비교를 위해서 시간을 밀리초 단위로 변형후 2개의 시간을 뺀다.

// Set the unit values in milliseconds. var msecPerMinute = 1000 * 60; var msecPerHour = msecPerMinute * 60; var msecPerDay = msecPerHour * 24; // Set a date and get the milliseconds var date = new Date('6/15/1990'); var dateMsec = date.getTime(); // Set the date to January 1, at midnight, of the specified year. date.setMonth(0); date.setDate(1); date.setHours(0, 0, 0, 0); // Get the difference in milliseconds. var interval = dateMsec - date.getTime(); // Calculate how many days the interval contains. Subtract that // many days from the interval to determine the remainder. var days = Math.floor(interval / msecPerDay ); interval = interval - (days * msecPerDay ); // Calculate the hours, minutes, and seconds. var hours = Math.floor(interval / msecPerHour ); interval = interval - (hours * msecPerHour ); var minutes = Math.floor(interval / msecPerMinute ); interval = interval - (minutes * msecPerMinute ); var seconds = Math.floor(interval / 1000 ); // Display the result. document.write(days + " days, " + hours + " hours, " + minutes + " minutes, " + seconds + " seconds."); //Output: 164 days, 23 hours, 0 minutes, 0 seconds.

Moment.js 를 이용하여 MSSQL DATE형에 맞는 포맷

moment().format("YYYY-MM-DD HH:mm:ss")