[empire-db] branch master updated: EMPIREDB-378 PostgeSQL: SQL Pattern for TIMESTAMP Columns

[derjan]

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

derjan pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/empire-db.git


The following commit(s) were added to refs/heads/master by this push:
     new 572b3f0  EMPIREDB-378 PostgeSQL: SQL Pattern for TIMESTAMP Columns
572b3f0 is described below

commit 572b3f0d41f6e13c408c62735cf714cc7b63e211
Author: Jan Glaubitz <j...@glaubitz.org>
AuthorDate: Mon Feb 28 12:56:02 2022 +0100

    EMPIREDB-378 PostgeSQL: SQL Pattern for TIMESTAMP Columns
---
 .../java/org/apache/empire/dbms/postgresql/DBMSHandlerPostgreSQL.java | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/empire-db/src/main/java/org/apache/empire/dbms/postgresql/DBMSHandlerPostgreSQL.java
 
b/empire-db/src/main/java/org/apache/empire/dbms/postgresql/DBMSHandlerPostgreSQL.java
index b6a3345..6aa5d67 100644
--- 
a/empire-db/src/main/java/org/apache/empire/dbms/postgresql/DBMSHandlerPostgreSQL.java
+++ 
b/empire-db/src/main/java/org/apache/empire/dbms/postgresql/DBMSHandlerPostgreSQL.java
@@ -345,10 +345,10 @@ public class DBMSHandlerPostgreSQL extends DBMSHandlerBase
             case SQL_CURRENT_DATE:            return "CURRENT_DATE";
             case SQL_DATE_PATTERN:            return "yyyy-MM-dd";
             case SQL_DATE_TEMPLATE:           return "'{0}'";
-            case SQL_DATETIME_PATTERN:        return "yyyy-MM-dd HH:mm:ss";
+            case SQL_DATETIME_PATTERN:        return "yyyy-MM-dd HH:mm:ss.SSS";
             case SQL_DATETIME_TEMPLATE:       return "'{0}'";
             case SQL_CURRENT_TIMESTAMP:       return "NOW()";
-            case SQL_TIMESTAMP_PATTERN:       return "yyyy-MM-dd HH:mm:ss";
+            case SQL_TIMESTAMP_PATTERN:       return "yyyy-MM-dd HH:mm:ss.SSS";
             case SQL_TIMESTAMP_TEMPLATE:      return "'{0}'";
             // functions
             case SQL_FUNC_COALESCE:           return "coalesce(?, {0})";