openerp-india team mailing list archive

[wowas <1002639@xxxxxxxxxxxxxxxxxx>]

Hello Tejas Tank,

I don't agree with you!

Because in statistical report code transform datetime to day, month and year. And don't worry about timezone.
This transformation lose absolute time! Because this day, month and year from UTC point view!
Web client don't able correct restore day, month and year from UTC day, month and year, because time information lost.
Error apear on border of day!

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1002639

Title:
  [6.1] TimeZone ERRORs in statistical reports

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  In All statistical reports, that use extract Date, Month and etc. from
  timestamp, there are an error on the border of days.

  For example in "crm\report\crm_lead_report.py":

                      to_char(c.create_date, 'YYYY') as creation_year,
                      to_char(c.create_date, 'MM') as creation_month,
                      to_char(c.create_date, 'YYYY-MM-DD') as creation_day,

  don't worry about timezone and convert to year, month and day in UTC time.
  But if we have stored date 2012-05-31 23:00:00 and our time zone +4hours we get ERRORs from such convertions.
  Local time must be 2012-06-01 03:00:00 and expected day - 1 JUNE, but we get day (for this record) - 31 MAY.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1002639/+subscriptions