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

How do I run a program in pl sql?

986

what is union, minus and interact commands? : Sql dba

1166

What is trigger and how to use it in sql?

1006

What is sql query optimization?

1087

what is data manipulation language? : Sql dba

988

explain about mysql and its features. : Sql dba

1002

How to add new employee details in an employee_details table with the following details

1078

How do I start sql from command line?

1000

how can we repair a mysql table? : Sql dba

956

What is difference between pls_integer and integer?

938

Define a temp table?

1003

Can we connect to postgresql using sql developer?

981

What is the difference between sql, mysql and sql server?

1067

How can we make an if statement within a select statement?

997

How does one load ebcdic data? : aql loader

1148