← Back to team overview

openerp-community team mailing list archive

Re: time zone adjustment in MAKO files?

 

Thanks Mike;

I very much appreciate your comments and time!

I'd just finished making something similar work:

import pytz
# ...
time_local = 'America/Chicago'
time_fmt = "%Y-%m-%d %H:%M"
arrive_dt = datetime.utcnow()
testDt=pytz.utc.localize(arrive_dt)
TestDt = testDt.astimezone(pytz.timezone(time_local))
Arrive=TestDt.strftime(time_fmt)

I appreciate you,
Dale


On Tue, May 14, 2013 at 2:37 AM, Michael Telahun Makonnen <
mmakonnen@xxxxxxxxx> wrote:

> Simply replacing timezone data does not work. You have to *convert* from
> one timezone to another.  But, because openerp doesn't attach timezone
> to the time in the database there is an initial step required to add utc
> timezone data. The general steps are:
> 1. Convert date/time from db into a naive datetime object
> 2. Attach utc timezone to get a timezone aware date/time object
> 3. Convert it to the timezone of your choice
>
> In practice it looks like this:
>
> from pytz import timezone
> tzutc = timezone('UTC')
> tzlocal = timezone('America/Chicago')
> dt = datetime.strptime(myobject.time_field, '%Y-%m-%d %H:%M:%S')
> utc_dt = tzutc.localize(dt, is_dst=False)
> local_dt = utc_dt.astimezone(tzlocal)
>
> Regards,
> Mike.
>
> On 05/10/2013 07:52 PM, Dale E. Moore wrote:
> > Does anyone know how to calculate local time in a mako report? This
> >
> > |from dateutil import tz
> > from_zone = tz.tzutc()
> > to_zone = tz.tzlocal()
> > arrive = arrive.replace(tzinfo=from_zone)
> > arrive_central = arrive.astimezone(to_zone)|
> >
> >
> > is not working for me.
> >
> >
> >
> > On Fri, May 10, 2013 at 8:30 AM, Dale E. Moore <daleemoore@xxxxxxxxx
> > <mailto:daleemoore@xxxxxxxxx>> wrote:
> >
> >     Thanks for the feedback Cristian Salamea!
> >
> >     The user preferences are America/Chicago but what's being
> >     displayed/printed is UTC.
> >
> >
> >     On Fri, May 10, 2013 at 8:05 AM, Ovnicraft <ovnicraft@xxxxxxxxx
> >     <mailto:ovnicraft@xxxxxxxxx>> wrote:
> >
> >
> >
> >
> >         On Fri, May 10, 2013 at 7:32 AM, Dale E. Moore
> >         <daleemoore@xxxxxxxxx <mailto:daleemoore@xxxxxxxxx>> wrote:
> >
> >             I've used
> >
> >
> >             |from dateutil import tz
> >
> >
> >
> >
> >
> >             from_zone = tz.tzutc()
> >
> >
> >
> >
> >
> >             to_zone = tz.tzlocal()
> >
> >
> >
> >
> >
> >             arrive = arrive.replace(tzinfo=from_zone)
> >
> >
> >
> >
> >
> >             arrive_central = arrive.astimezone(to_zone)|
> >
> >
> >
> >             in hr_timesheet_invoice_create.py to output the correct
> >             local time but that isn't working for me in some MAKO
> reports.
> >
> >             Do you know how to get the correct local time out of a MAKO
> >             report?
> >
> >
> >         Hello, AFAIK you always must compute in UTC, TZ comes from user
> >         preferences.
> >
> >         Regards,
> >
> >
> >             I look forward to hearing from you,
> >             DaleEMoore@xxxxxxxxx
> >
> >
> >
> >             _______________________________________________
> >             Mailing list: https://launchpad.net/~openerp-community
> >             Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> >             <mailto:openerp-community@xxxxxxxxxxxxxxxxxxx>
> >             Unsubscribe : https://launchpad.net/~openerp-community
> >             More help   : https://help.launchpad.net/ListHelp
> >
> >
> >
> >
> >         --
> >         Cristian Salamea
> >         @ovnicraft
> >
> >
> >
> >
> >
> > _______________________________________________
> > Mailing list: https://launchpad.net/~openerp-community
> > Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> > Unsubscribe : https://launchpad.net/~openerp-community
> > More help   : https://help.launchpad.net/ListHelp
> >
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>

References