Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need help in writing a SQL query regarding Date

 
Ravi Kiran Va
Ranch Hand
Posts: 2234
Eclipse IDE Firefox Browser Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

There is a column called as IN_TIME in our table . Till now i am firing queries based on the exact date as



Now my query is , is it possible to fire a query as i want to get all the data before 22 - MAR-10

My question is how to get all the values before 22-MAR-10

Thanks
 
Rajendar Goud
Ranch Hand
Posts: 220
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can use the sql query as follows..


SELECT *
FROM TABLE_NAME
WHERE IN_TIME <= '22-MAR-10';

this shall fetch all the values less than the mentioned date
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic