Home › Discussions › Questions & Answers › Timezone Conversion Utility Functions
Customer · · Questions & Answers · 5 replies
We need to display dates in our custom report that are accurately converted to the client’s local timezone. Which `XXEN_UTIL` function handles this?
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.
And if I have a date entered by the user on the client side that I need to convert back to the server time for processing?
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.
Does the conversion logic handle daylight savings time automatically?
The functions check for differences in time zones between the client and server based on the profile values and perform the conversion accordingly.
Sign in with LinkedIn or Google to take part.
