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 text? : Sql dba

1060

How to change the order of columns in Oracle SQL Plus ?

1042

How many rows can sqlite handle?

1094

What is error ora-01000: maximum open cursors exceeded

1129

What is oracle pl sql developer?

966

what are the types of join and explain each? : Sql dba

1026

What is auto increment feature in sql?

1111

Explain the working of primary key?

1078

What is the max nvarchar size?

947

When can we use the where clause and the having clause?

1011

What is pl sql record in oracle?

1015

What is left join in sql?

1041

What is sql indexing?

1002

What is full form of rtm?

994

Can there be 2 primary keys in a table?

989