SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire

Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Question Posted / nitin umale

Answer Posted / 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';

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to rename a column in the output of sql query?

1125

How can check sql version from command line?

1138

What is a pl/sql block?

1328

How do we use distinct statement? What is its use?

1075

How do I count duplicates in sql?

1177

How do I enable sql encryption?

1072

Which kind of parameters cannot have a default value in pl sql?

1212

Can you upgrade sql express to full sql?

1141

What are the packages in pl sql?

1065

What are the different types of functions in sql?

1099

what is self join and what is the requirement of self join? : Sql dba

1191

Does inner join remove duplicates?

998

What is the file extension for sql database?

1063

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1172

How can you create an empty table from an existing table?

1127