MySQL Forums :: Newbie :: Storing Java Timestamp (long) in database as BIGINT?


Advanced Search

Storing Java Timestamp (long) in database as BIGINT?
Posted by: Ivan Yung ()
Date: November 24, 2010 11:19AM

Here's a table-design question....

A Java developer wants to store the Java timestamp value, which is a LONG datatype which its value represents milliseconds, directly into the table. I'm in the camp that "if you want a datetime in there, stick it to the DB as a datetime/timestamp. I just don't like having saved as BIGINT.

What's your take, and the pros/cons? The table is populated and read by the java application most of the time, and of course there will be occassional SELECT from the table for research purposes.

Thanks!

Options: ReplyQuote


Subject Written By Posted
Storing Java Timestamp (long) in database as BIGINT? Ivan Yung 11/24/2010 11:19AM
Re: Storing Java Timestamp (long) in database as BIGINT? Rick James 11/25/2010 02:10PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.