Timezone Conversion Utility Functions

You should use the function `XXEN_UTIL.CLIENT_TIME(p_date in date)`. It takes a date in the server’s timezone and converts it to the client’s local timezone, provided the ‘Server Timezone’ and ‘Client Timezone’ profile options are set.

For the reverse operation, use `XXEN_UTIL.SERVER_TIME(p_date in date)`. This function converts a date from the client timezone back to the server timezone if a difference is detected.

The functions check for differences in time zones between the client and server based on the profile values and perform the conversion accordingly.