Logo 
Search:

Oracle FAQ

Submit Interview FAQ
Home » Interview FAQ » OracleRSS Feeds

Name of serial’s name which has been started two year ago.

  Shared By: Shruti Sharma    Date: Dec 15    Category: Oracle    Views: 1251

Answer:

SQL>select serialname from serial_master where to_char(timeinindia ,'DD-MON-YYYY hh:mi:ss a.m.') <= '05-aug-2000 12:59:59'

SERIALNAME
----------
Kundali
Kmg
Ksbkbthi

Share: 
 
 
 
 



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


Tagged: