WITH RECURSIVE `cte` AS (
(SELECT `id`, `locationid`, `eventid`,
TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(`list`, ','), ',', 1), ',', -1)) AS `date`,
1 AS `idx`
FROM `test`
HAVING `date` != '')
UNION
(SELECT `t`.`id`, `t`.`locationid`, `t`.`eventid`,
TRIM(SUBSTRING_INDEX(SUBSTRING_INDEX(CONCAT(`t`.`list`, ','), ',', `cte`.`idx` + 1), ',', -1)) AS `date`,
`cte`.`idx` + 1
FROM `cte`
JOIN `test` AS `t` ON `t`.`id` = `cte`.`id`
HAVING `date` != '')
),
SELECT `id`, `locationid`, `eventid`,
CONCAT (SUBSTRING(`date`, 7, 4), '-', SUBSTRING(`date`, 4, 2), '-', SUBSTRING(`date`, 1, 2)) AS `date`
FROM `cte`
HAVING `date` >= :firstDate AND `date` < :lastDate
https://www.vodomer-24.ru/?name=x&phone=y&text=z
Channel: PJSIP/номер@канал
MaxRetries: 2
RetryTime: 60
WaitTime: 30
Context: контекст_воспроизведения_сообщения
Extension: экстеншин_воспроизведения_сообщения
Priority: приоритет_воспроизведения_сообщенияCN=Group,CN=Schema,CN=Configuration,DC=example,DC=comif (numOrStr == null) {
console.log('вы отменили');
} else if (numOrStr == '') {
console.log('Empty String');
} else if (numOrStr == numOrStr) { // условие всегда истинно
console.log(' number is Ba_NaN');
} else {
console.log('OK!'); // недостижимый код
}isNaN(Number(numOrStr)).
Files SHOULD either declare symbols (classes, functions, constants, etc.) or cause side-effects (e.g. generate output, change .ini settings, etc.) but SHOULD NOT do both.
const date = new Date(1670063686503);
// Date Sat Dec 03 2022 13:34:46 GMT+0300 (Москва, стандартное время)
date.toGMTString();
// "Sat, 03 Dec 2022 10:34:46 GMT"
date.toISOString();
// "2022-12-03T10:34:46.503Z"const dataValues = { id_key: 'A005012', std: 0 };
const t = 'std';
dataValues[t] = 1;
console.log(dataValues);
// { id_key: "A005012", std: 1 }