This week's giveaway is in the Spring forum.
We're giving away four copies of Learn Spring Security (video course) and have Eugen Paraschiv on-line!
See this thread for details.
Win a copy of Learn Spring Security (video course) this week in the Spring 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