Bug #1006
Update Bangladesh server to Bangladesh time zone
Start date:
12/12/2013
Due date:
% Done:
0%
Description
Update the Bangladesh server to GMT6 (Bangladesh time zone):
1. Check tables that store time in date columns;
2. Update these data to Bangladesh time zone;
3. Switch Bangladesh server time zone to GMT6;
History
#1
Updated by Maurício Dos Santos about 11 years ago
- Status changed from New to Feedback
Ricardo,
Have you done those changes?
There is still a problem on transaction log time displaying, we need to talk about this.
#2
Updated by Ricardo Memoria about 11 years ago
- Status changed from Feedback to In Progress
These are the tables/fields that require update:
- CaseComment.date
- ErrorLog.errorDate
- Forecasting.recordingDate
- Issue.creationDate
- Issue.answerDate
- IssueFollowup.followupDate
- Movement.recordDate;
- Order.orderDate;
- Order.approvingDate;
- OrderComment.date;
- TransactionLog.transactionDate;
- User.registrationDate
- UserLogin.loginDate;
- UserLogin.logoutDate;
I'll run the script to adjust time-zone from US to Bangladesh this afternoon.
Mauricio - Please make sure you fixed all pages that display date-time using the tables above.
#3
Updated by Ricardo Memoria about 11 years ago
- Status changed from In Progress to Resolved
- Assignee changed from Ricardo Memoria to Luis Gustavo do Valle Bastos
timestamp fields updated, server timezone changed to UTC+06:00, and everybody is happy!
#4
Updated by Ricardo Memoria over 8 years ago
- Status changed from Resolved to Closed