Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display student details born in year 1980 to 1982 using to_char() function

Posted By: Lucas Silva     Category: Oracle     Views: 2391

Display student details born in year 1980 to 1982 using to_char() function.

Code for Display student details born in year 1980 to 1982 using to_char() function in Oracle

select * from student where to_char(birthdate,'yyyy') in('1980','1981','1982');

Output:

    ROLLNO NAME           CLASS      BIRTHDATE
---------- -------------  --------   ---------

         4 Mona Amin       B         08-APR-81
         5 Tikku Thakkar   B         15-DEC-82
  
Share: 

 
 
 


Lucas Silva
Lucas Silva author of Display student details born in year 1980 to 1982 using to_char() function is from Salvador, Brazil.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!