Home › Discussions › Questions & Answers › Utility Functions for Date/Timezone Conversion

Utility Functions for Date/Timezone Conversion

Avatar photoCustomer Questions & Answers 3 replies

Our reports must display server-recorded dates converted accurately to the client’s local timezone. Which `XXEN_UTIL` function performs this conversion?

3 replies

  • Support Enginatics

    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.

  • Avatar photoCustomer

    And if I need to perform the reverse operation for a client-entered date?

  • Support Enginatics

    For the reverse operation (client time back to server time), use `XXEN_UTIL.SERVER_TIME(p_date in date)`.

  • You must be logged in to reply to this post.