Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    2

    Unanswered: Mysql BigInteger time question

    Hi,

    I got hold of a DB that i am using to practice webdevelopment using Java.
    Now, the problem is that in a table, i have BigInteger that is used torepresent time.

    Now, is it possible to represent data with BigInteger?

    If i change datatype i will have to change some code. I was thinking of creating a method to convert the BigInteger to time in some way.

    Example: if i use 2000 to represent 20:00, i can convert the BigInteger to string, and then modify the string to add the :

    I would like to get some advice before proceeding.

    Thanks in advance.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Please post a date/time and the corresponding BIGINT value. The BIGINT values are often coded in peculiar ways (one common example is minutes past Jan 1, 1970), and without knowing how they are coded I'd be afraid to answer your question.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •