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 <niph...@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/**
>>> 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.
>
>
>
--
---
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.
