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 :: current date in postgresql minus 1 day
Sql :: sql percentage
Sql :: postgres show databases
Sql :: mysql ip address data type
Sql :: java sql timestamp now
Sql :: mysql date range
Sql :: replace null value within column mysql
Sql :: how to combine first and last nae into one columb sql
Sql :: sql drop column
Sql :: postgre describe table
Sql :: 1) PostgreSQL DESCRIBE TABLE using psql
Sql :: add primary key with auto increment to existing table column mysql
Sql :: postgres select as csv
Sql :: varchar vs nvarchar sql
Sql :: in mysql workbench contnent not feching
Sql :: SQL Error 1040 : Too many connections
Sql :: IS NOT NULL statement
Sql :: postgresql get date now
Sql :: SQL Multiple Cases
Sql :: SQL ORDER BY ASC (Ascending Order)
Sql :: install postgresql 10 centos 7
Sql :: Inner join - to join 3 tables - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/
Sql :: json with root element in sql server
Sql :: reset auto increment mysql
Sql :: postgres like case insensitive
Sql :: opening xampp mysql in cmd ubuntu
Sql :: sql precent format
Sql :: sql server remove primary key without dropping table
Sql :: update foreign key value in mysql
Sql :: select random rows sql