Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL TIME

 
S Quintin
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can I convert a time value returned by SQL (in a 10 digit format) by hand?

Thanks.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch!

The first thing is to figure out what the number means for your database. Is it milliseconds since January 1st, 1970 or something else.

At that point, I would write a program to load the number into a java.util.Date object and output it. (You could do this with a calculator if you had to, but I can't imagine why you want to do that. Accounting for leap years and the like would be a nuisance.)

If you were using JDBC to get the SQL TIME, you could call rs.getTimeStamp and output that directly.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic