File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Customer Requirements for Developers
this week in the
JDBC and Relational Databases
Need help in writing a SQL query regarding Date
Ravi Kiran Va
Joined: Apr 18, 2009
Mar 23, 2010 01:27:29
There is a column called as IN_TIME in our table . Till now i am firing queries based on the exact date as
IN_TIME LIKE '19-MAR-10' , This is working fine .
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
Save India From Corruption - Anna Hazare.
Joined: Mar 06, 2002
Mar 23, 2010 02:01:44
You can use the sql query as follows..
WHERE IN_TIME <= '22-MAR-10';
this shall fetch all the values less than the mentioned date
It is sorta covered in the
JavaRanch Style Guide
subject: Need help in writing a SQL query regarding Date
Would this book be helpful for ejb learning?
SQL Column Date Type insertion problem
Generate date in 2011-04-26T16:52:57-05:00 format.
Convert String to Date
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015