# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1556208855 -7200
# Node ID 7d041f5c3feae751df46be74230fe154728fc3dc
# Parent  30ecff9acf47b75b18da40f336cb312a9b0f9440
In getTimeDateFunctions() also return newly added SQL function: date_trunc

diff --git a/ChangeLog b/ChangeLog
--- a/ChangeLog
+++ b/ChangeLog
@@ -16,7 +16,7 @@
 - Improved MonetDatabaseMetaData methods:
   - getNumericFunctions(): it no longer lists aggregate functions: avg, prod and sum
   - getSystemFunctions(): it no longer lists timedate function: extract
-  - getTimeDateFunctions(): it now also lists function: epoch
+  - getTimeDateFunctions(): it now also lists functions: date_trunc, epoch
 - Corrected MonetDatabaseMetaData method getTypeInfo() for result column
   SEARCHABLE. It now returns DatabaseMetaData.typeSearchable for all
   string data types including 'inet','json','url','uuid' and 'blob'.
diff --git a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
--- a/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
+++ b/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java
@@ -532,7 +532,7 @@ public class MonetDatabaseMetaData exten
 	@Override
 	public String getTimeDateFunctions() {
 		String wherePart =
-			 "\"mod\" IN ('mtime','timestamp') OR \"name\" IN ('localtime','localtimestamp')";
+			 "\"mod\" IN ('mtime','timestamp') OR \"name\" IN ('localtime','localtimestamp','date_trunc')";
 		String unionPart =
 			// add time date functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
 			" UNION SELECT 'extract'" +