select *,upper(datename(dw,gedate())) as dayofweek from employee where up

Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Question Posted / sankarapandian

Answer Posted / sankarapandian

select *,upper(datename(dw,gedate())) as dayofweek from
employee where upper(Convert(varchar(15),datename dw,gedate
())))='MONDAY'

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is cursor in pl sql?

1186

What is form and report?

1052

How to Declare Fixed Length String Value In PL SQL

1207

What is cross join example?

1064

Is sql a microsoft product?

995

What are the parameter modes supported by pl/sql?

1153

Explain spool.

1219

explain normalization concept? : Sql dba

1089

What is the use of stored procedures?

1105

Is id a reserved word in sql?

1187

What are the advantages of stored procedure?

1039

What is pl sql and why it is used for?

1157

What is sql not null constraint?

1093

How do you use a while loop in pl sql?

1053

What is memory optimized?

1133