How can I display timestamps or dates in the clients time zone
I have a simple apex application, hosted on a server in the US. However, the users are in the UK.
I have a table using the data type 'timestamp with local time zone' to store dates. I have set the default value for the field in apex to 'sysdate' and the display format mask to 'dd-mon-yyyy hh:mm' but it always uses the time from the server (US) rather than client (UK).
I have tried re-creating the table using a 'date' data type but thats not working either.
I have also tried setting 'automatic time zone' in the application properties, but that doesn't help either.
How can I achieve this?
Thanks,
Richard