We conducted several scenarios to replicate the timezone problem. These scenarios were performed on the client side with II_TIMEZONE_NAME set to GMT2, while the server used II_TIMEZONE_NAME PHILIPPINES.\n\n1. Directly inserting the current date('now') into the database via ISQL.\n2. Inserting the actual date and time value (e.g., 05-jun-2023 12:00:00) into the database via ISQL.\n3. Running the SELECT date('now') query via ISQL and comparing it to the server.\n4. Using OpenROAD, passing the value of SELECT date('now') to a variable and using that variable to insert into the database. The data type of the variable was set to date, and we also tried setting it to varchar.\n\nRESULT:\nOn the client side, the date and time values are displayed in GMT2. When compared to the server side, the date and time values are in the PHILIPPINE timezone, resulting in the correct time being posted.