Show timestamp in human readable format while respecting time zone

Summary:

Display the date and time from the last_connect column in the fnd_sessions table in a human readable format. The time should also respect British Summer Time / Daylight Savings Time.

Content (required):

The time and date in the last_connect is in the format 2023-05-29T13:30:28.000+00:00. The output should be along the lines of: 29/05/2023 14:30. Note that the date is in the format DD-MM-YYYY and the time is one hour ahead. The result can be in either one or two columns.

My time zone is GMT or Europe/London. We are currently observing British Summertime which is GMT+1. The timestamp is recorded in UTC.