diff src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java @ 275:7d041f5c3fea

In getTimeDateFunctions() also return newly added SQL function: date_trunc
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 25 Apr 2019 18:14:15 +0200 (2019-04-25)
parents ee4c826e3933
children 4face9f42efc 34e3f5d4232b
line wrap: on
line diff
--- 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'" +