Project:
| View Revisions: Issue #27628 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0027628: Some DateTime fields are not converted to the proper timezone | ||
| Revision | 2014-11-12 12:10 by alostale | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column Attached module with steps 1) and 2) 3) Do the following update in the database, in order to have the same dates in the new column and in the updated column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. 6) Display the field in grid view. Notice that now the field is showing the correct time both in form and in grid view. Alternative steps (can be reproduced in livebuilds.openbravo.com): 1. Set different timezones in browser and server 2. Go to Process monitor 3. In grid select a record and check its Start Time 4. Go to form view -> OK same Start Time is shown 5. Go back to grid view and remove Start Time column from grid 6. Go to form view -> Start Time has changed |
||
| Revision | 2014-11-12 09:10 by caristu | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column Attached module with steps 1) and 2) 3) Do the following update in the database, in order to have the same dates in the new column and in the updated column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. 6) Display the field in grid view. Notice that now the field is showing the correct time both in form and in grid view. |
||
| Revision | 2014-11-12 09:09 by caristu | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column Attached module with steps 1) and 2) 3) Do the following update in the database, in order to have the same dates in the new column and in the update column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. 6) Display the field in grid view. Notice that now the field is showing the correct time both in form and in grid view. |
||
| Revision | 2014-11-12 09:08 by caristu | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column Attached module with steps 1) and 2) 3) Do the following update in the database, in order to have the same dates in the new column and in the update column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. 6) Display the field in grid form. Notice that now the field is showing the correct time both in form and in grid view. |
||
| Revision | 2014-11-11 09:29 by caristu | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column Attached module with steps 1) and 2) 3) Do the following update in the database, in order to have the same dates in the new column and in the update column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. |
||
| Revision | 2014-11-11 09:28 by caristu | ||
| Steps To Reproduce | 1) Create a new column of type DateTime, for example in the m_productprice table 2) Create a field for this new column 3) Do the following update in the database, in order to have the same dates in the new column and in the update column: update m_productprice set newcolumn = updated 4) Put the server and the client in different timezones, for example the server in GMT+1 and the client in GMT+2 5) Access from the client to the Price tab in the Product window. Notice that the conversion is not applied for the new field. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |