Home › Discussions › Questions & Answers › How does Blitz Report handle timezones for date parameters?

How does Blitz Report handle timezones for date parameters?

Avatar photoCustomer Questions & Answers 7 replies

We have timezone conversions enabled on our EBS instance. How does Blitz Report handle input for a parameter defined as ‘Date’ type, compared to one defined as ‘DateTime’ type?

7 replies

  • Support Enginatics

    The Parameter Type definition controls this validation and conversion. For a Date parameter type, even if timezone conversions are enabled, the entered value is used as a bind for SQL execution without any conversion (using midnight of the date entered).

  • Avatar photoCustomer

    And for ‘DateTime’?

  • Support Enginatics

    For a DateTime parameter type, which includes the timestamp, if timezone conversions are enabled, the entered parameter value will be converted to server time before being used as a bind for SQL execution.

  • Avatar photoCustomer

    Does the system check if the date entered is valid?

  • Support Enginatics

    Yes, the parameter type definition specifically controls the validation of parameter values at run-time, ensuring the input matches the defined type (Char, Date, DateTime, Number, LOV types).

  • Avatar photoCustomer

    If I need to convert a date from the server timezone to the client timezone in a SQL query, is there a utility function?

  • Support Enginatics

    Yes, you can use the custom database function `XXEN_UTIL.CLIENT_TIME (p_date in date)`. This function converts the date from the server’s timezone to the client’s local timezone if a difference is detected.

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