/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

1 vote192 views1 answer
How to get mysql db size
SQL
0 vote188 views1 answer
View t-sql mail configuration
SQL
0 vote192 views1 answer
Sql inserted
SQL
0 vote214 views1 answer
Sql server concat null
SQL
0 vote212 views1 answer
How to get one year old query from plan cache
SQL
2 votes215 views3 answers
How to check current user in mySQL
SQL
0 vote202 views1 answer
Mysql create pool
SQL
1 vote282 views1 answer
Size of all tables in a schema oracle
SQL
4 votes274 views1 answer
Postgresql list sequences
SQL
3 votes199 views1 answer
Mysql UPDate with enner join
SQL

Share