[fineract] branch 1.8.3 updated: FINERACT-1835: Backported fix of `Wrong audit time is set for datatables`

[aleks]

This is an automated email from the ASF dual-hosted git repository.

aleks pushed a commit to branch 1.8.3
in repository https://gitbox.apache.org/repos/asf/fineract.git


The following commit(s) were added to refs/heads/1.8.3 by this push:
     new 7d2121d8c FINERACT-1835: Backported fix of `Wrong audit time is set 
for datatables`
7d2121d8c is described below

commit 7d2121d8cd50f962f8b423fbf7cd7cbb6c17ccd4
Author: Adam Saghy <adamsa...@gmail.com>
AuthorDate: Wed Dec 14 09:47:32 2022 +0100

    FINERACT-1835: Backported fix of `Wrong audit time is set for datatables`
---
 .../core/service/database/DatabaseSpecificSQLGenerator.java           | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/fineract-provider/src/main/java/org/apache/fineract/infrastructure/core/service/database/DatabaseSpecificSQLGenerator.java
 
b/fineract-provider/src/main/java/org/apache/fineract/infrastructure/core/service/database/DatabaseSpecificSQLGenerator.java
index a11a0b58f..ccec2f22a 100644
--- 
a/fineract-provider/src/main/java/org/apache/fineract/infrastructure/core/service/database/DatabaseSpecificSQLGenerator.java
+++ 
b/fineract-provider/src/main/java/org/apache/fineract/infrastructure/core/service/database/DatabaseSpecificSQLGenerator.java
@@ -110,9 +110,9 @@ public class DatabaseSpecificSQLGenerator {
 
     public String currentTenantDateTime() {
         if (databaseTypeResolver.isMySQL()) {
-            return format("TIMESTAMP('%s')", 
DateUtils.getLocalDateTimeOfTenant().format(DateUtils.DEFAULT_DATETIME_FORMATER));
+            return format("TIMESTAMP('%s')", 
DateUtils.getLocalDateTimeOfSystem().format(DateUtils.DEFAULT_DATETIME_FORMATER));
         } else if (databaseTypeResolver.isPostgreSQL()) {
-            return format("TIMESTAMP '%s'", 
DateUtils.getLocalDateTimeOfTenant().format(DateUtils.DEFAULT_DATETIME_FORMATER));
+            return format("TIMESTAMP '%s'", 
DateUtils.getLocalDateTimeOfSystem().format(DateUtils.DEFAULT_DATETIME_FORMATER));
         } else {
             throw new IllegalStateException("Database type is not supported 
for current date time" + databaseTypeResolver.databaseType());
         }