DAYNAME() function to get full name of the weekday in MySQL
https://www.plus2net.com/sql_tutorial/date-dayname.php
By using any date and input, we can get full day name
SELECT DAYNAME(‘2020-09-21’);
We can get todays day name in full by using CURDATE() function
SELECT DAYNAME(CURDATE());
We can also get yesterday name
SELECT DAYNAME(CURDATE()-INTERVAL 1 DAY);
Next day name in full
SELECT DAYNAME(CURDATE() + INTERVAL 1 DAY);
Previous day name , todays name and tomorrow day name
SELECT DAYNAME(CURDATE()- interval 1 DAY) as yesterday,
DAYNAME(CURDATE()) as today,
DAYNAME(CURDATE()+ INTERVAL 1 DAY) as Tomorrow
Видео DAYNAME() function to get full name of the weekday in MySQL автора PHP и шаблоны
Видео DAYNAME() function to get full name of the weekday in MySQL автора PHP и шаблоны
Информация
1 декабря 2023 г. 19:55:16
00:04:02
Похожие видео
