Answer / prasant

SELECT FIRST_NAME,LAST_NAME FROM employees
where TRIM(TO_CHAR(TO_DATE(HIRE_DATE),'DAY'))='MONDAY';

if any issue,contact me.

Answer / kiran kumar

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

Answer / kavitha nedigunta

select ename
from emp
where trim(to_char(Hiredate,'day')) ='monday'

Answer / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Answer / nitin umale

SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire_date
FROM employees
WHERE UPPER(TRIM(TO_CHAR(hire_date, 'day')))='MONDAY';

Answer / ajeet

select last_name,to_char(hire_date,'day,mm,yyyy')
from employees
where trim(to_char(Hire_date,'day')) ='monday'

Answer / mahendar reddy

SELECT ENAME FROM EMP WHERE TO_CHAR(TO_DATE(HIREDATE),'D')='2';

IT fetch the employee name who joined on monday
Here
1=sunday
2=monday
--
---
--
--
--etc

Answer / chaitu

select ename,to_char(hiredate,'Day') from emp
where trim( to_char(hiredate,'Day'))='Monday'

Answer / emmanuel

Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';

Answer / venkat

Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;

1-SUNDAY
2-MONDAY
----
7-SATURDAY

The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

how to include character strings in sql statements? : Sql dba

0 Answers  

What are user defined stored procedures ?

3 Answers   BirlaSoft,

What is the purpose of my sql?

0 Answers  

what is innodb? : Sql dba

0 Answers  

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

What are pl/sql cursor exceptions?

0 Answers  

How toimport .dmp file in lower version of oracle from higher version ?

4 Answers   TCS,

What is a full join sql?

0 Answers  

when is the use of update_statistics command? : Sql dba

0 Answers  

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

0 Answers  

What is sql and also describe types of sql statements?

0 Answers