/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

0 vote296 views1 answer
Why do we need data structure in sql
SQL
1 vote305 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote278 views1 answer
Sql query use select name inside where clause
SQL
0 vote284 views1 answer
How to find total working hour in sql
SQL
0 vote285 views1 answer
Oracle webcenter content search enginer
SQL
0 vote295 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote292 views1 answer
Cannot pip install mysqlclient
SQL
0 vote263 views1 answer
Add computed column to table sql server
SQL
0 vote268 views2 answers
Wordpress change url in database
SQL
8 votes274 views1 answer
Oracle current date plus 1 month
SQL

Share