Thanks Niphlod. May I know where I can pick up the examples? 

Appreciate your help on 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/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.
>>> -- 
>>>  
>>> --- 
>>> 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+un...@googlegroups.com.
>>> For more options, visit 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.


Reply via email to