> "If no time zone is stated in the input string, then it is assumed to > be in the time zone indicated by the system's timezone parameter" > > So the server_time_zone should be set to the time zone of the db > server machine itself.
> If I added explicit support for Pg's "... with time zone" data types, > I'd imagine it'd be straightforward to simply have the DateTime > objects spit out their time zones in the formatted string passed to > the db. But AFAICT, the existing Timestamp (without time zone) column > class in RDBO should work okay with some care even if the underlying > column type is "timestamp with time zone." maybe there could be some way for RDBO to query the machein for the timezone or something? granted, i mostly use NOW() on the db-- but i try to force everything into GMT. i'm sick of localized time. i've moved servers from la- >ny->la->ny too many times. i like working with GMT for everything and then just adjust from there. | - - - - - - - - - - - - - - - - - - - - | RoadSound.com / Indie-Rock.net | Collaborative Online Management And Syndication Tools | - - - - - - - - - - - - - - - - - - - - ------------------------------------------------------------------------- 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