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)); Thanks for help. X.Chen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
