All, CS – 1898 :: UI : incorrect time conversion on UI under Events
https://issues.apache.org/jira/browse/CLOUDSTACK-1898 I am proposing to change/redesign the way CS handles times and dates currently. We have time conversion issue on UI due to Time Zones. Time Zones is not a mandatory field and if left blank CS will use its default time zone and Users will see time on their UI's off. (Refer to bug and attached screen for clarification) (Unless of course they are in default time zone that CS would use, when no time zone is supplied) Once upon a time…there was a table in a database , named Event….. mysql> select * from event; +-----+--------------------------------------+---------------------------+-----------+-------------------------------------------------------------------------------------------+---------+------------+-----------+---------------------+-------+----------+------------+----------+ | id | uuid | type | state | description | user_id | account_id | domain_id | created | level | start_id | parameters | archived | +-----+--------------------------------------+---------------------------+-----------+-------------------------------------------------------------------------------------------+---------+------------+-----------+---------------------+-------+----------+------------+----------+ | 1 | 746273bb-a6ed-453a-8e45-a9873d06c58e | USER.LOGIN | Completed | user has logged in from IP Address 10.216.132.50 | 2 | 2 | 1 | 2013-04-01 22:26:12 | INFO | 0 | NULL | 0 | | 2 | f8323212-fe8f-4d3c-a1c8-40d26b217895 | USER.CREATE | Completed | Successfully completed creating User. Account Name: test, Domain Id:1 | 2 | 1 | 1 | 2013-04-01 22:49:50 | INFO | 0 | NULL | 0 | Now assume 2 users; 1.Admin and 2.User with User created by Admin using "Pacific time Zone". When these 2 Users log in on UI, they both will see Event 1 (From Table above) with different times. (Of course Admin) Admin will see it as 2013-04-01 22:26:12 +/- Time Zone specified when this user was created. Similarly user will see this same event with time +/- "Time Zone specified when this user was created". (Pacific Time , in our example) As per existing implementation, a Traveling "User", Either logs in from London Or Tokyo; "if this User was created using PST", then he will have time off all the time during his travel. DISCUSS:: To Prevent CS – 1898 - Should we actually store time/date in DB in some standard format. And then display it by converting based on User's (Client Browser's) time/zone. - Or should we instead make Time Zone field mandatory? (In this case we still have traveling user problem).
