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

Can you selectively load only those records that you need? : aql loader

1023

Explain lock escalation? : Transact sql

1173

what is top in tsql? : Transact sql

1086

Explain what is table in a database?

1045

Can we use delete in merge statement?

1029

How do you declare a variable in pl sql?

1007

Mention what is the function that is used to transfer a pl/sql table log to a database table?

971

Which is faster count (*) or count 1?

1009

What are the types of operators available in sql?

1050

What is procedure explain with example?

938

What is a sql*loader control file?

1232

define data blocks ? : Sql dba

968

What is nvarchar in sql?

916

How many postgresql users are there, worldwide?

1044

What does closing a cursor do?

1302