"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/11/2005 20:28:38:
> Hi, all > > I have a question like this: > > There's a field in table_A, date_time, if I say this in Mysql: > > select min(date_time), max(date_time) from table_A; > > it returned something like this: > > +---------------------+---------------------+ > | min(date_time) | max(date_time) | > +---------------------+---------------------+ > | 2003-05-06 11:59:00 | 2003-05-23 11:59:00 | > +---------------------+---------------------+ > > My question is that if I used JDBC like this: > > String sqlcmd = "select min(date_time), max(date_time) from table_A; > Statement Stmt = conn.createStatement(); > ResultSet RS = Stmt.executeQuery(sqlcmd); > > How should I get the values, like this? > > start_time=RS.getString(1); > end_time=RS.getString(2); > > or > > start_time=RS.getString(min(date_time)); > end_time=RS.getString(max(date_time)); You could do String start_time = RS.getString (1) ; but you would be much better advised, in my opinion, to do java.sql.Date start_time = RS.getDate (1) ; which then allows you to use all the Java library's excellent date handling features. Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]