select * from emp where TO_CHAR(hiredate,'Q')=3; 'Q'

how to get the third quarter of employee details from emp?

Question Posted / eshwer

2 Answers
7798 Views
CompuTech, I also Faced
E-Mail Answers

Answer Posted / eshwer

select * from emp where TO_CHAR(hiredate,'Q')=3;

'Q' Regrives the all the 4 quarters(1,2,3,4) details on
that we retrive the 3 quarter details

Please check it

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is attribute indicator in pl sql?

961

what is difference between delete and truncate commands? : Sql dba

1067

Does sql between include endpoints?

955

What is a heap in sql?

994

Can we rollback after truncate?

982

What are types of joins?

910

What is sql*loader and what is it used for? : aql loader

1097

How to Declare Fixed Length String Value In PL SQL

1104

when is the use of update_statistics command? : Sql dba

973

What are all the common sql functions?

971

what is the difference between blob and text? : Sql dba

964

What are all the different types of indexes?

1092

What is the difference between distinct and unique in sql?

876

What is sql query optimization?

1023

How do I view tables in mysql?

917