Sql

select format(columnName, 'dddd') as WeekDay from tableName; -- SQL Server 17

SELECT WEEKDAY(date);

SELECT TO_CHAR(your_table.date_colunm, 'DAY')
FROM your_table;

PREVIOUS	NEXT

Code Example
Sql :: date_add mysql
Sql :: oracle add month
Sql :: oracle sql day of month from date
Sql :: check mysql port
Sql :: v$session table or view does not exist
Sql :: drop table sql
Sql :: postgresql group by month and year
Sql :: LoadError: cannot load such file -- mysql2/2.7/mysql2
Sql :: t SQl Checking Your Username
Sql :: sql fillna
Sql :: ksql terminate all queries
Sql :: sql convert unix time to date
Sql :: mysql one week ago
Sql :: how to update column name in psql
Sql :: sql replace character in string in all records
Sql :: alter table add column with default value
Sql :: sql if null then 0
Sql :: alter tablespace add datafile
Sql :: mysql Like(searching in the string)
Sql :: where clause for child record apex
Sql :: how to change the value of a table in sql
Sql :: get last week data in mysql
Sql :: mysql alter table modify column
Sql :: sql drop database if exists
Sql :: clear a table in mysql
Sql :: how to create new user and database postgresql in ubuntu
Sql :: mysql create database with collation
Sql :: delete record mysql query
Sql :: order by oracle
Sql :: oracle drop index if exists