# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1742483578 -3600
# Node ID ef11627b87cb65cc65c838d0249b4ecf85867906
# Parent  5cc071c5c170f3f095634785b8411481c0ef8217
Let getTimeDateFunctions() return functions sys.dayname and sys.monthname when the server supports them.
Those will be supported from MonetDB server v11.53 (March2025).

diff --git a/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java b/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
--- a/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
+++ b/src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java
@@ -482,7 +482,7 @@ public final class MonetDatabaseMetaData
 		final String wherePart =
 			 "\"mod\" IN ('mtime','timestamp')" +
 			// include Date/Time functions which are located in 'str' module
-			" OR f.\"name\" IN ('localtime','localtimestamp','date_trunc')";
+			" OR f.\"name\" IN ('localtime','localtimestamp','date_trunc','dayname','monthname')";
 		final 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'" +