Well, Timestamp does not seem appropriate since LocalTime does not have a date associated, and Time could be but it lacks the millis value (only hour, minutes and seconds).
I see two options: use Time (losing the millis value), which IMHO think covers the needs of 99% of the prople, or use a long value. I think the first is the best, and if someone needs the second, it's easy to write a second version. More thoughts? I have already implemented one, if I find time will prepare a test (the contrib project does not have any) Regards, Right now, I was thinking On 1/25/07, Mario Ivankovits <[EMAIL PROTECTED]> wrote: > Hi Ignacio! > > The question is, my idea is to persist the Duration as the > > milliseconds value, but I am not sure about what to do with LocalTime. > > Using milliseconds of the day sounds good, but (a) it's much harder to > > restore the LocalTime value from the SQL value, and (b) it's harder to > > read by visual inspection of the database. My second idea was to use a > > "hh:MM:ss.mmm" format, persisted as a String. > > > Isn't it possible to simply store the milliseconds into the database > with a date/timestamp column? > As far as I know the database do not necessarily maintain a timezone, so > there should be no problem to do so and any database query tool will be > able to show a human readable representation of if. > > Ciao, > Mario > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > _______________________________________________ > Joda-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/joda-interest > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Joda-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/joda-interest
