| set @interval = 24; -- in hours
use... |
7 years ago |
| set @interval = 24; -- in hours
use... |
7 years ago |
| set @interval = 24; -- in hours
use... |
7 years ago |
| set @interval = 24; -- in hours
use... |
7 years ago |
| set @interval = 24; -- in hours
use... |
7 years ago |
| set @interval = 24; -- in hours
use... |
7 years ago |
| select DATE_FORMAT('20171026203636', '%e %M %Y %H:%i:%s') |
7 years ago |
| select DATE_FORMAT('20171026203636', '%D %M %Y %H:%i:%s') |
7 years ago |
| select DATE_FORMAT('20171026203636', '%Y-%M-$d %H:%i:%s') |
7 years ago |
| select DATE_FORMAT('20171026203636') |
7 years ago |
| DATE_FORMAT('20171026203636') |
7 years ago |
| set @interval = 24 * 5; -- in hours
use ruwiki_p;
select... |
7 years ago |
| set @interval = 48;
select now() - interval @interval hour + 0 |
7 years ago |
| set @interval = 2
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2;
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2;
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2;
select now() - interval @interval day + 0 |
7 years ago |
| use ruwiki_p;
set @interval = 2;
select now() - interval @interval day + 0 |
7 years ago |
| use ruwiki_p;
set @interval = 2;
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2
select now() - interval @interval day + 0 |
7 years ago |
| set @interval = 2 DAY
select now() - interval @interval + 0 |
7 years ago |
| select now() - interval 2 day + 0 |
7 years ago |
| select NOW() - INTERVAL 2 DAY + 0 |
7 years ago |
| select NOW() - INTERVAL 2 DAY + 0 |
7 years ago |
| select NOW() - INTERVAL 2 DAY |
7 years ago |
| select NOW() - INTERVAL 2 DAYS |
7 years ago |
| select NOW() + 0 |
7 years ago |
| select CURRENT_TIMESTAMP |
7 years ago |
| select (CURDATE() + 0 + CURTIME() + 0) |
7 years ago |
| select CURDATE() + 0 |
7 years ago |
| select CURDATE() + 0 |
7 years ago |
