tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Darren Lee Deliang" <just_dar...@hotmail.com>
Subject SQL statement
Date Thu, 27 Jul 2000 14:23:31 GMT
Hi guys see if you can help me out on this:

i need to extract only certain rows from a database based on the month and 
year selected by the user compared against a value in the database called 
startdate. is it like that?

//======================================================================

Part of the codes (Prepared Statement)

"SELECT * FROM ApplicationRecord WHERE MONTH(startDate) = ? AND 
YEAR(startDate) = ?"

st.setString(1, month);
st.setString(2, year);

//======================================================================

Wat is the exact syntax for extracting the month or year value of a 
timestamp object from an database (SQL Server)?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


Mime
View raw message