Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Fetching Time from Resultset

 
Srikrishna DhumalRao
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
-->

Arnaud
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic