select ename,to_char(hiredate,'Day') from emp where trim( to

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

Question Posted / chaitu

Answer Posted / chaitu

select ename,to_char(hiredate,'Day') from emp
where trim( to_char(hiredate,'Day'))='Monday'

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is bcp? When does it used? : Sql dba

995

Why is partition used in sql?

1130

What is inner join in sql?

1087

What is program debugging?

1259

What is sql table?

978

What are the main features of cursor?

1072

what is a trigger in mysql? : Sql dba

1152

What are the different dcl commands in sql?

1181

Can we insert data into view?

909

How do you truncate?

915

How can we debug in PL/SQL?

1137

How do I write a sql query in pgadmin 4?

994

What is the difference between the conventional and direct path loader? : aql loader

1157

Can I create table without primary key?

1004

How do I make sql search faster?

1003