Class Javascript tutorial 3

function msToTime(duration) {
  var milliseconds = parseInt((duration % 1000) / 100),
    seconds = Math.floor((duration / 1000) % 60),
    minutes = Math.floor((duration / (1000 * 60)) % 60),
    hours = Math.floor((duration / (1000 * 60 * 60)) % 24);

  hours = (hours < 10) ? "0" + hours : hours;
  minutes = (minutes < 10) ? "0" + minutes : minutes;
  seconds = (seconds < 10) ? "0" + seconds : seconds;

  return hours + ":" + minutes + ":" + seconds + "." + milliseconds;
}
// console.log(msToTime(300000))
// output: 00:05:00.0

// get time difference between two dates in seconds 
var startDate = new Date();
// Do your operations
var endDate   = new Date();
var seconds = (endDate.getTime() - startDate.getTime()) / 1000;
var milliseconds = (endDate.getTime() - startDate.getTime());

[, OPTIONAL second param [, OPTIONAL ... param]]
static Date.now() // returns the number of milliseconds elapsed since January 1, 1970 00:00:00 UTC.
parse(dateVal) //  Date.parse('05 Dec 1998 00:12:00 GMT'); // return 912816720000
toDateString() // sunday 19.7.2020
toTimeString() // 20:15:37
getDate() // 1-31
getDay() // 0-6, 0 == Sunday
var now = new Date();
var dayOfWeekSundayIs7 = now.getDay() == 0)?7:now.getDay();
getFullYear() // 2020
getHours() // 0-23
getMilliseconds() // eg. 956
getMinutes() //  0-59
getMonth() // 0 january 
getSeconds() // 0-59
getTime() // https://en.wikipedia.org/wiki/Unix_time
getTimezoneOffset() //returns the time zone difference, in minutes, from current locale 
getYear() //does not return full years ("year 2000 problem"), it is no longer used and has been replaced by the getFullYear() method.
setDate(numDate) // 1-31 day of month
setHours(numHours[, numMin[, numSec[, numMilli]]]) // now.setHours(20, 21, 22); 20:21:22
setMilliseconds(numMilli) // 0-999
setMinutes(numMinutes[, numSeconds[, numMilli]]) // 0-59, 0-59, 0-999
setMonth(numMonth[, dateVal]) // 0-11
setSeconds(numSeconds[, numMilli]) 0-59 [, 0-999]
setYear(numYear) // not set full years ("year 2000 problem"), it is no longer used and has been replaced by the setFullYear() method.
setUTCDate() // 
setUTCFullYear(2020) // 2020 sets the full year for a specified date according to universal time GMT
setUTCHours()
setUTCMilliseconds()
setUTCMinutes()
setUTCMonth()
setUTCSeconds()

toLocaleTimeString()
var options = { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' };
now.toLocaleDateString(undefined, options); //neděle 19. července 2020

// PDT Pacific Daylight Time (UTC -7)
// GMT ... SET GMT TIME +- ZONE ... new Date('December 31, 1974 23:59:30 GMT-3:00');
toGMTString() // DEPRECATED!!!! use toUTCString()
// Using UTC instead GMT!!!
var d = new Date("2020-07-15T00:00:00.000+07:00"); // UTC + 7
console.log(d.toISOString());  // "2020-07-14T17:00:00.000Z"
console.log(d.valueOf());      // 1594746000000

toISOString() // "2020-07-14T17:00:00.000Z"
toJSON() // "2020-07-14T17:00:00.000Z"
toSource() //This feature is obsolete!!!! Dont use!!!!
toString() // "Tue Jul 14 2020 19:00:00 GMT+0200 (Středoevropský letní čas)"
toUTCString() // "Tue, 14 Jul 2020 17:00:00 GMT"
valueOf() // 1594746000000

(function () {

    String.prototype.isString = true;

    String.prototype.trim = function () { return this.replace(/(^\s*)|(\s*$)/g, "") };

    String.prototype.endsWith = function (a) { return this.substr(this.length - a.length) == a };

    String.prototype.startsWith = function (a) { return this.substr(0, a.length) == a };

})();

$dst = date("I"); //I (capital i); 0 or 1 if daylight saving time

// example:
$hour = 14;
if(date("I")===1){
 $hour = $hour + 1;
}
// OR
$hour = 14 + date("I");

Sqlite3 příkazy - rady zkušenosti

sqlite3 my_database.db .dump > output.sql

pause

Plnění databáze ze souboru.sql

sqlite3 new_database.sqlite < output.sql

pause

Plnění databáze ze souboru TXT, kde jednotlivé sloupce jsou odděleny středníkem

sqlite3 dictionary_database.db < load.sql

CREATE TABLE [es_cz] (
[spanish] VARCHAR(255)  NULL,
[czech] VARCHAR(255)  NULL

);

.separator ";"
.import spanish-czech.txt es_cz

spanish word;czech word
spanish word;czech word
spanish word;czech word

Výpis databáze do CSV souboru

sqlite3.exe -header -csv myDatabase.db "select * from myTable;" > test.csv

Ukázky zaokrouhlení čísla v JavaScript.

var num = 123.45678;
var rounded = Math.round(num); // out: 123
 
var num = 123.5269;
var rounded = Math.round(num); // out: 124

var num = -3.5269;
var rounded = Math.round(num); // out: -4

var num = 3.5269;
var rounded = Math.round(num * 100)/100; // out: 3.52

var num = 3.5269;
var rounded = Math.round(num * 1000)/1000; // out: 3.526

var num = 3.5269;
var rounded = num.toFixed(3); // out: 3.527

c:xampphtdocs