GeeCON Prague 2014*
The moose likes JDBC and the fly likes sql querry for date. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "sql querry for date." Watch "sql querry for date." New topic
Author

sql querry for date.

sachin komurlekar
Greenhorn

Joined: May 09, 2001
Posts: 14
i want to get the names of all workers from a table who have joined after a particular date(eg after 1997).
the table is having the name of workers who have joined from 1985 till 2000.
please give me sqlcoding that can be used in jdbc.
i am using MSaccess as back end.
Smita Tyagi
Greenhorn

Joined: May 09, 2001
Posts: 21
Hello Sachin,
You can use a prepared statement like this:
PreparedStatement stat = myConn.prepareStatement("Select name from table where (joining_date between ? and ?)");
stat.setString(1,beginingDate);
stat.setString(2,endDate);
you try this and let me know whether it works.
Smita
 
GeeCON Prague 2014
 
subject: sql querry for date.