Hi All,
The requirement is that we do get a time value with time zone in a CSV in text format (ex: 12:00 CET), which we read and display on UI. When displaying the time on the UI we need to display it in GMT. With the current datetime functions this seems to be difficult to achieve.
Other thing in mind is that maintain a table with time zone off set values for different time zones we get and use it to calculate the correct display value. This has its own issue like day light saving adjustments.
But before going into that route we need to find if we can still do this easily programmatically.
Any advice is appreciated.
Ex:
Time value received in CSV : 12:00 CET
on UI we need to display 10:00 GMT
Discussion posts and replies are publicly visible