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
10413 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

How do I view a procedure in sql?

913

what is primary key? : Sql dba

956

Is nosql relational?

896

How does sql*loader handles newline characters in a record? : aql loader

987

What is the difference between nested table and varray?

944

how many sql ddl commands are supported by 'mysql'? : Sql dba

959

Is join an inner join?

898

What is %type in pl sql?

926

Why truncate is used in sql?

938

how to enter characters as hex numbers? : Sql dba

995

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

What does count (*) do in sql?

954

How can check sql version from command line?

1014

Define select, insert, create, delete, update, drop keywords

997

what is auto increment? : Sql dba

965