operate the database in the client's time zone

Marco Vargas-113764

Organization Name

Nicomar Electronics

Description

We need our system at the database level to work with the client's time zone, i.e. Colombian time, not U.S. database time. The time zone changes but at the application level in the interface, but it does not work, so all transactions are recorded in the time zone that the database is in the system. That is, this way the Colombian time zone will appear in the system, in the internal records of the system and the databases will remain with the time zone where the server and its database are located.

 

Use Case and Business Need

all our transactions are reflected in the system with the u.s. time, which does not make it easy to keep track of the transaction for audit and consultation and closing dates that the volume of sales is too high in nicomar, we must generate transactions until 7pm otherwise stay with the 01 of the next month, which harms nicomar in times of operation and sales

More details

it only works at the interface level, it is changed and for the user the time of Colombia appears, but when carrying out transaction queries in the database they are left with the time of the United States, not the local time

Original Idea Number: 9c04d7cb68