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

How to return an array from java to pl/sql?

1109

what are different types of collation sensitivity? : Sql dba

1055

Explain correlated query work?

1038

How does rowid help in running a query faster?

1401

What is sql catalog?

999

Can we commit inside a trigger?

977

Explain how exception handling is done in advance pl/sql?

985

What is sqlca in powerbuilder?

993

Why having clause is used in sql?

957

What are the uses of merge?

1150

Why do we use joins?

1017

how to get help information from the server? : Sql dba

914

What is an ndf file?

973

How do you copy a table in sql?

1047

What is the use of procedures?

963