SELECT * FROM EMP where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))=�

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

Question Posted / kiran kumar

Answer Posted / kiran kumar

SELECT * FROM EMP
where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))='SUNDAY'

Is This Answer Correct ?

23 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is right join in sql?

1020

What is use of package in pl sql?

949

what is a record in a database ? : Sql dba

995

What is pivot in sql?

871

Can a key be both primary and foreign?

943

What are the two types of exceptions in pl/sql?

965

What is rename in sql?

915

What is structural independence and why is it important?

978

How do I quit sql?

897

Which sorts rows in sql?

967

What is the difference between alter trigger and drop trigger statements?

1042

What is count * in sql?

934

How do you create a db file?

956

What are sql ddl commands?

1019

What are crud methods?

969