timezone info on datetime values ignored

[Ethan Furman]

If a datetime value is given to OpenERP with timezone information, the timezone is stripped and the value is treated as UTC.

OpenERP 7.0

[Twinkle Christian(OpenERP) (tch-openerp)]

Hello Ethan,

Would you please provide more information on this issue ? As I am not understand with this enough information. Please provide proper scenario.

Waiting for your answer.
Thanks .

[Ethan Furman (ethan-stoneleaf)]

I have a module which lets the user set a date and a time for a certain operation. Because the datetime widget is difficult to use I have them enter the data as a separate date field and time field, which I then combine into a third datetime field. If I submit this calculated datetime field as-is, OpenERP thinks it's in the UTC timezone. When I add the local timezone info to the calculated datetime so that I am now passing a timezone aware object to OpenERP, OpenERP ignores it and still treats it as a naive datetime in the UTC timezone.

Here's the code from my module:

    def _calc_appointment(self, cr, uid, ids, _field=None, _arg=None, context=None):
        if context is None:
            context = {}
        result = {}
        user_tz = get_user_timezone(self, cr, uid)[uid]
        if user_tz:
            user_tz = timezone(user_tz)
        for id in ids:
            result[id] = False
            record = self.browse(cr, uid, id, context=context)
            date = record.appointment_date
            time = record.appointment_time or 0.0
            if date:
                if not user_tz:
                    continue
                dt = DateTime.combine(Date(date), Time.fromfloat(time)).datetime()
                dt = user_tz.localize(dt)
                result[id] = dt
        return result

    _columns = {
        ...
        'appointment_date': fields.date('Appointment date', help="Date when driver should arrive."),
        'appointment_time': fields.float('Appointment time', help="Time when driver should arrive."),
        'appointment': fields.function(_calc_appointment, type='datetime', string='Appointment',
                store={'fnx.sr.shipping': (_calc_appointment, ['appointment_date', 'appointment_time'], 10)}),
         ...

[Launchpad Janitor (janitor)]

[Expired for OpenERP Server because there has been no activity for 60 days.]