/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 vote208 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote213 views1 answer
Select row with latest date mysql
SQL
3 votes219 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote232 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
3 votes219 views2 answers
Search text in all sql server stored procedure
SQL
1 vote197 views1 answer
Oracle rolling back
SQL
1 vote207 views1 answer
How to see which columns are indexxed mysql
SQL
4 votes208 views1 answer
Id increment ms sql server
SQL
11 votes200 views2 answers
Import sql file laravel cmd
SQL
8 votes241 views6 answers
Insert command in sql
SQL

Share