Answers for "how to get date and time from datetime in sql"

how to get date in sql

SELECT CURRENT_DATE from dual;

Posted by: Guest on January-28-2021

sql day from datetime

SET @@lc_time_names = 'fr_FR';
SELECT DAYNAME('2000-01-01') dayname;
+---------+
| dayname |
+---------+
| samedi  |
+---------+

Posted by: Guest on January-11-2021

Code answers related to "how to get date and time from datetime in sql"