Adding timezone value in normal datetime

Question

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' bu

Prakash · Accepted Answer

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

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

muhammed ashraf · 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 (

Ben Bernard · 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.

Related Posts	Replies	Views
Create selection type field dynamically? openerp	2 Sep 23	6394
Time zone problem in python timezone	2 Apr 23	1729
How to hide the create button dynamical tree view in openerp ? Solved openerp	2 Mar 23	44268
ProgrammingError: can't adapt type 'dict' [SOLVED] openerp	2 Dec 23	54322
How to use the audit app openerp	0 Mar 22	1026

This question has been flagged

Enjoying the discussion? Don't just read, join in!