Sorry Niphlod. I was on my phone, and didn't see this attachment. Thanks again for helping me out without asking for anything. I will try to learn from your example.
On Fri, Apr 19, 2013 at 8:33 AM, Funmanhk <funma...@gmail.com> wrote: > Btw, I want to say that Niphlod has been very helpful. I am definitely > missing the HTML+JS knowledge, but that didn't stop me to try out in web2py > and have a good attempt on this issue. > > I am one little step away from solving this time zone problem haunting me > for a few months. I wouldn't have the courage to start this adventure > without seeing the community's effort here. > > Thanks Niphlod, and everyone to create and support this. > > On 19 Apr, 2013, at 3:13, Niphlod <niph...@gmail.com> wrote: > > packed an app with a few examples: might explain better how to deal with > timezones. > > On Thursday, April 18, 2013 6:20:18 PM UTC+2, fun man wrote: >> >> yes. I am with you. I didn't store timezone in the db, and will be using >> UTC for all input to the db too. >> >> I hope to find a way to use the detected timezone to use in the >> .represent method for the sqlform.grid. >> db.prototype.modified_on.**represent = lambda value, row : >> pytz.UTC.localize(value).**astimezone(pytz.timezone('**Asia/Tokyo')) >> >> The above is working for me. I basically hardcode it to 'Asia/Tokyo'. I >> am trying to get the value from your plugin to replace my hard coded one >> above. >> >> >> On Fri, Apr 19, 2013 at 12:41 AM, Niphlod <nip...@gmail.com> wrote: >> >>> the whole point of timezone normalization is NOT having "a timezone >>> attached at the end". >>> It's storing in the database as UTC and displaying as "localized" to the >>> users. >>> Are we sure that you fully grasped what the timezone implementation on >>> the IS_DATE* validators in web2py and that that idea fits with your one ? >>> >>> >>> On Thursday, April 18, 2013 4:35:51 PM UTC+2, fun man wrote: >>> >>>> i am not using any specific language translation. It should be the >>>> default language. >>>> >>>> i also think that it is timezone issue, but not very sure how to do the >>>> normalization. The model i use is Field('modified_on', 'datetime'), >>>> I see that there is no timezone attached at the end. >>>> >>>> >>>> On Thu, Apr 18, 2013 at 7:11 PM, Niphlod <nip...@gmail.com> wrote: >>>> >>>>> that seems more a problem with the format of the date than the fact >>>>> that it has to be "timezone-normalized"....what language translation are >>>>> you using ? >>>>> >>>>> PS: what I meant with "landing page" is that you're sure that the user >>>>> will hit that page before arriving to the form. >>>>> If you are sure, there's no need to embed the LOADed fragment in the >>>>> form page >>>>> >>>>> -- >>>>> >>>>> --- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit https://groups.google.com/d/**to >>>>> **pic/web2py/aV1nNiDIwiY/**unsubsc**ribe?hl=en<https://groups.google.com/d/topic/web2py/aV1nNiDIwiY/unsubscribe?hl=en> >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> web2py+un...@**googlegroups.com. >>>>> >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> -- >>> >>> --- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "web2py-users" group. >>> To unsubscribe from this topic, visit https://groups.google.com/d/** >>> topic/web2py/aV1nNiDIwiY/**unsubscribe?hl=en<https://groups.google.com/d/topic/web2py/aV1nNiDIwiY/unsubscribe?hl=en> >>> . >>> To unsubscribe from this group and all its topics, send an email to >>> web2py+un...@**googlegroups.com. >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/aV1nNiDIwiY/unsubscribe?hl=en. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > > <web2py.app.fun_man.w2p> > > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.