Fetching Time from Resultset

[Srikrishna DhumalRao]

Hi,
I have to get the time in minutes from a date column in database.
I am using rs.getTime() which returns a java.sql.Time object .my problem is to convert it into minutes - is there any built in method for this job.
Thanks

[Arnaud Burlet]

Hi,

it depends on what you need, but first note that your java.sql.Time extends Date, so you inherit methods from Date class...


- you need to know how much minutes are in your java.sql.Time object.
--> rs.getTime().getTime() will give you milliseconds since January 1, 1970, 00:00:00 GMT, just divide...

- you need to know how much minutes within the hour, use a Calendar
-->

Calendar c = new Calendar();
c.setTime(rs.getTime());
c.get(Calendar.MINUTE);

Arnaud