Skip to Content
This question has been flagged
timezoneopenerp
3 Replies
16068 Views
Avatar
Ashish Singh

import pytz

from datetime import datetime
from datetime import timedelta

from openerp import SUPERUSER_ID

        user_pool = self.pool.get('res.users')
        user = user_pool.browse(self.cr, SUPERUSER_ID, self.uid)
        tz = pytz.timezone(user.partner_id.tz) or pytz.utc
        # Suppose 'tz' fetch 'Asia/Kolkata'

# Suppose date_end = '2014-06-17 16:25:25'
        date_from = pytz.utc.localize(datetime.strptime(date_end, "%Y-%m-%d %H:%M:%S")).astimezone(tz)

#        Now if i print date_form --->'2014-06-17 16:25:25+05:30' but i want to print it in '2014-06-17 21:55:25'

please help me guys

Thanks

Avatar
Discard
Avatar
Prakash
Best Answer

http://stackoverflow.com/questions/79797/how-do-i-convert-local-time-to-utc-in-python

Avatar
Discard
Ashish Singh
Author

Thanks Prakash

Avatar
muhammed ashraf
Best Answer

I have the same problem and solving through this function passing DateTime would be converted to UTC format and your timezone to save on the database as UTC 

def convert_TZ_UTC(self,mydate, tz):
    tz = tz if tz else self.env.user.tz
    fmt = "%Y-%m-%d %H:%M:%S"
    # Current time in UTC
    now_utc = datetime.now(timezone('UTC'))
    # Convert to current user time zone
    now_timezone = now_utc.astimezone(tz)
    UTC_OFFSET_TIMEDELTA = datetime.strptime(now_utc.strftime(fmt), fmt) - datetime.strptime(now_timezone.strftime(fmt),
                                                                                             fmt)
    local_datetime = datetime.strptime(mydate.strftime(fmt), fmt)
    result_utc_datetime = local_datetime + UTC_OFFSET_TIMEDELTA
    return result_utc_datetime.strftime(fmt)


Avatar
Discard
Avatar
Ben Bernard
Best Answer

You really have to check tz value. If this happen

'2014-06-17 16:25:25+05:30' but i want to print it in '2014-06-17 21:55:25'

then tz = pytz.utc.

Avatar
Discard
Ashish Singh
Author

Thanks Ben Bernard

Related Posts Replies Views Activity
Create selection type field dynamically?
openerp
Avatar
Avatar
Avatar
2
सित॰ 23
8630
Time zone problem in python
timezone
Avatar
Avatar
2
अप्रैल 23
4230
How to hide the create button dynamical tree view in openerp ? Solved
openerp
Avatar
Avatar
2
मार्च 23
47916
ProgrammingError: can't adapt type 'dict' [SOLVED]
openerp
Avatar
Avatar
Avatar
2
दिस॰ 23
59100
How to use the audit app
openerp
Avatar
0
मार्च 22
3163