Getting Hrs and Minutes of java.sql.Date

Didn't really get what you meant by "separatly". You should take a look at the DateFormat in the Java API

for example:

SimpleDateFormat formatter = new SimpleDateFormat("HH:mm");

out.print(formatter.format(t));

will print 23:00 when the pub closes ;)

alban.maillerea at 2007-7-9 22:49:30 >

You need to convert your sql time to a Calendar object.

java.sql.Time time = rs.getTime("time_field");

Calendar cal = Calendar.getInstance();

// set the calendar to have your time

cal.setTimeInMillis(time.getTime());

int hour = cal.get(Calendar.HOUR);

int minutes = cal.get(Calendar.MINUTE));

ricardo_joa at 2007-7-9 22:49:30 >