/SQL/Sql day from datetime

Sql day from datetime

Sql day from datetime

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

0

Source: mysqltutorial.org

Sql: extract day text from datetime value

SELECT DATENAME(dw,'09/23/2013') as theDayName

0

Source: stackoverflow.com

Similar codes

2 votes140 views1 answer
Query any digits record
SQL
0 vote117 views1 answer
How to execute stored output to csv files
SQL
0 vote149 views1 answer
Hierarchal database table
SQL
0 vote131 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
11 votes145 views2 answers
Having keyword sql
SQL
0 vote100 views1 answer
Sql runnignsum
SQL
20 votes125 views2 answers
Counting in sql
SQL
4 votes87 views1 answer
And or sql order of operations
SQL
0 vote117 views1 answer
Install mysql 8 linux
SQL
1 vote122 views1 answer
Woocommerce mysql price table
SQL

Share