Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get weekday from old date in sql

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

extract weekday from date in sql

SELECT WEEKDAY(date);
Comment

get week day from date in sql

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

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 
ADD CONTENT
Topic
Content
Source link
Name
7+1 =