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

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

Question Posted / kiran kumar

Answer Posted / kiran kumar

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

Is This Answer Correct ?

23 Yes

7 No

Please Help Members By Posting Answers For Below Questions

what is a field in a database ? : Sql dba

541

How does one load ebcdic data? : aql loader

643

Is clustered index a primary key?

526

What are triggers and its types?

551

define sql delete statement ? : Sql dba

556

What are types of indexes in sql?

537

How do I use google cloud in sql?

536

How do you modify a trigger?

524

What is the default isolation level in sql server? : Transact sql

564

How do you declare a constant?

523

How does cross join work?

502

How does postgresql compare to oracle/db2/ms sql server/informix?

563

How many databases can sql express handle?

530

How do I run a sql query?

528

what is myisam? : Sql dba

574