Yikes! I forgot about the dates going back into the database! This kind of stuff takes a second to wrap my head around, conceptually.
I'm thinking: Database -> HTML ---------------- - All timestamps stored in the database are set in timezone. - Even if they are not standardized, as long as a timestamp has a timezone and isn't floating than DateTime or Postgres can do the math. - The RoseDB object's server_time_zone is set to... ...the server's time zone, PST8PDT. - Create a date_format function that will take the DateTime object returned by any Rose::DB::Object and format it against the users timezone/locale preferences. - Call that function from within the template itself. Sound's good? ....Sometime I'd like to help polish the documentation. I'm just now learning all this locale / timezone business and it can get pretty daunting with all the CPAN modules involved. The date handling doc's are scattered over many modules. I completely missed the stuff you pasted while browsing the documentation. I hate to think about all the other cool stuff I could be doing, but don't know about yet! For example, can I get a log of generated SQL queries without setting $Debug =1 in the QueryBuilder? If so, I'm not sure which module would have the documentation for it, and I've checked them all & the mailing list... Maybe I could help set up a more "proper," organized manual like Template::Toolkit has. The content is all written, it is just a matter of organization. I'd also like to add some examples that aren't just "here is how to set up the object in some very abstract way" but are "here is your $object called in your code and here are the cool, practical things you can do with it". Regardless, thanks for the help!! -- Cory R. King John Siracusa wrote: > RDBO's bundled timestamp and date/time column types do have the ability to > convert DateTime objects to a canonical time zone before storing them in > database. > cut! < > -John ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
