I would suggest that you need to store a normalised version of the date in the database and localize when you read it back out. Storing different formats in the DB will lead to confusion.
Stephen Maxim Veksler wrote: > Hello Friends, > > For our setup joda-time runs in a webapp, on top of Tomcat6. The webapp > talks to an Oracle database which will have it's NLS setting put into > place correctly. > > How would you recommend setting joda-time (Does this means JVM / Tomcat > installation configurations?) so that this will be in sync with the > oracle installation? > > How does this affects joda-time? I'm currently using this wonderful > library to calculate week of year settings. Obviously this is timezone / > geographical dependent setting because I might be following the ISO > standard for week calculation (Quick explanation [1]) or I might be > following some different algorithm for week [2]. > > > Pointers, references and generally help on this issue is appreciated. > > Thank you, > Maxim > > [1] > http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm#sthref302 > [2] http://en.wikipedia.org/wiki/Seven-day_week#Week_numbering > > // This might seem a little newbie question, which it is. > // I think the whole concept of timezones is a complex enough issue to > be very very careful with before claiming you "know your stuff". > > -- > Cheers, > Maxim Veksler > > "Free as in Freedom" - Do u GNU ? > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > > > ------------------------------------------------------------------------ > > _______________________________________________ > Joda-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/joda-interest ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ Joda-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/joda-interest
