Answers for "get today's date query in sql php mysql"

SQL
6

mysql current date

In MySQL the CURDATE() returns the current date in 'YYYY-MM-DD' format or 'YYYYMMDD' format depending on whether numeric or string is used in the function. CURRENT_DATE and CURRENT_DATE() are the synonym of CURDATE()
Posted by: Guest on May-29-2020
0

mysql set variable to today's date

SELECT CAST(CURRENT_DATE() AS CHAR(50)) INTO @today;
SELECT CAST(DATE_ADD(CURRENT_DATE, INTERVAL -1 DAY) AS DATE) INTO @yesterday;

SELECT @today, @yesterday
Posted by: Guest on November-02-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language