SQL> select ename,hiredate from emp where trim(to

Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)

Question Posted / l meher

5 Answers
10834 Views
I also Faced
E-Mail Answers

Answer Posted / l meher

SQL> select ename,hiredate from emp where trim(to_char(trunc(hiredate),'DAY')) = 'MONDAY';

ENAME HIREDATE
---------- ---------
MARTIN 28-SEP-81

Is This Answer Correct ?

10 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of triggers?

1084

How can you load microsoft excel data into oracle? : aql loader

1216

Can a table contain multiple primary key’s?

1155

What are inner and outer joins examples of both?

1009

Sql technical questions

1336

Can there be more than one function with a similar name in a pl/sql block?

1044

How to create your own reports in sql developer?

1066

In what condition is it good to disable a trigger?

1073

What is the difference between microsoft access and sql server?

1108

what is single byte over head in oracle..?

2458

Is postgresql a server?

1114

How do you optimize a query?

1060

Why is pl sql used?

1030

What is rollback?

1186

What are the rules to be applied to nulls whilst doing comparisons?

1370