В этом уроке расскажу: - что такое функции даты и времени в SQL; - как использовать DATE(); - как использовать MONTH(); - как использовать MONHNAME(); - как использовать YEAR(); - как использовать DAY(); - как использовать DAYOFMONTH(); - как использовать DAYOFWEEK(); - как использовать DAYOFYEAR(); - как использовать DAYNAME(); - как использовать HOUR(); - как использовать MINUTE(); - как использовать SECOND(); - как использовать NOW(); - как использовать SYSDATE(); - как использовать CURRENT_TIMESTEMP(); - как использовать EXTRACT(); - как использовать ADDDATE(); - как использовать SUBDATE(); - как использовать DATEDIFF(); - как использовать DATE_FORMAT(); - как использовать TIME_FORMAT(). 00:37 DATE() 03:37 DATE() с условием 06:49 DATE() + BETWEEN 11:30 MONTH() 13:21 MONHNAME() 14:12 YEAR() 16:11 DAY() 16:38 DAYOFMONTH() 16:50 DAYOFWEEK() 17:06 DAYOFYEAR() 17:20 DAYNAME() 18:25 HOUR() 18:35 MINUTE() 18:45 SECOND() 19:42 NOW() 19:58 SYSDATE() 20:07 CURRENT_TIMESTEMP() 20:37 EXTRACT() 22:30 ADDDATE() 24:41 SUBDATE() 25:20 DATEDIFF() 26:08 DATE_FORMAT() 28:00 TIME_FORMAT() 30:01 bee smart. логическая задачка use university; select date('2023-04-30'); select date('2023-04-30 12:34:56'); alter table student add test_time datetime; update student set test_time = '2023-04-22 11:00:00' where studentID = 1; update student set test_time = '2023-04-23 11:40:02' where studentID = 2; update student set test_time = '2023-04-24 11:40:02' where studentID = 3; update student set test_time = '2023-04-20 15:01:40' where studentID = 4; update student set test_time = '2023-04-21 10:05:00' where studentID = 5; update student set test_time = '2023-05-01 10:30:05' where studentID = 6; update student set test_time = '2023-05-22 12:00:00' where studentID = 7; update student set test_time = '2023-04-24 11:12:00' where studentID = 8; update student set test_time = '2023-04-23 11:00:12' where studentID = 9; update student set test_time = '2023-04-22 01:13:00' where studentID = 10; update student set test_time = '2023-04-22 01:30:13' where studentID = 11; update student set test_time = '2023-04-15 11:14:00' where studentID = 12; update student set test_time = '2023-04-21 13:50:14' where studentID = 13; update student set test_time = '2023-04-22 13:17:00' where studentID = 14; update student set test_time = '2023-04-23 14:18:00' where studentID = 15; update student set test_time = '2023-04-27 15:21:19' where studentID = 16; update student set test_time = '2023-04-17 13:22:20' where studentID = 17; update student set test_time = '2023-04-13 10:30:05' where studentID = 18; select test_time from student; select date(test_time) from student; select date(test_time) from student where test_time = '2023-04-13 10:30:05'; select * from student where date(test_time) = '2023-04-23'; select test_time from student where date(test_time) between '2023-04-20' and '2023-04-24'; select date(test_time) from student where date(test_time) between '2023-04-20' and '2023-04-24'; select month('2023-04-24'); select month('2023-10-13 10:30:05'); select month(test_time) from student; select * from student where month(test_time) = '04'; select monthname('2023-04-24'); select monthname(test_time) from student; select year('2023-04-24'); select year('2023-10-13 10:30:05'); select year(test_time) from student; select * from student where year(test_time) = '2023'; select last_name, test_time from student where year(test_time) = '2023' and month(test_time) = '05'; select day(test_time) from student; select dayofmonth(test_time) from student; select dayofweek(test_time) from student; select dayofyear(test_time) from student; select dayname(test_time) from student; select hour('2023-04-22 18:00:00'); select minute('2023-04-22 18:10:00'); select second('2023-04-22 18:00:40'); select now(); select sysdate(); select current_timestamp(); select extract(second from '2023-04-22 18:03:40'); select extract(day from '2023-04-22 18:03:40'); select extract(week from '2023-04-22 18:03:40'); select extract(minute_second from '2023-04-22 18:03:40'); select extract(day_second from '2023-04-22 18:03:40'); select * from student where date(test_time) = adddate('2023-04-23', interval -10 day); select * from student where date(test_time) = subdate('2023-04-23', interval 1 day); select datediff(curdate(),date_of_birth) from student; select date_of_birth, date_format(date_of_birth, '%d %m %y %w') from student; select test_time, time_format(test_time, '%H %i %s') from student; Ответ на задачку об парковочном месте: 87 Если вам понравилось это видео, кликни «Мне нравится» и не забудь подписаться! Хорошего настроения!🐝 #база данных #реляционная база данных #базы данных для начинающих #select #bee_tester #date #time #datetime