Mercurial > hg > monetdb-java

comparison src/main/java/org/monetdb/jdbc/MonetDatabaseMetaData.java @ 968:ef11627b87cb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Let getTimeDateFunctions() return functions sys.dayname and sys.monthname when the server supports them. Those will be supported from MonetDB server v11.53 (March2025).
author Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
date Thu, 20 Mar 2025 16:12:58 +0100 (4 weeks ago)
parents 39b74cc688d2
children
comparison
equal deleted inserted replaced
967:5cc071c5c170 968:ef11627b87cb
480 @Override 480 @Override
481 public String getTimeDateFunctions() { 481 public String getTimeDateFunctions() {
482 final String wherePart = 482 final String wherePart =
483 "\"mod\" IN ('mtime','timestamp')" + 483 "\"mod\" IN ('mtime','timestamp')" +
484 // include Date/Time functions which are located in 'str' module 484 // include Date/Time functions which are located in 'str' module
485 " OR f.\"name\" IN ('localtime','localtimestamp','date_trunc')"; 485 " OR f.\"name\" IN ('localtime','localtimestamp','date_trunc','dayname','monthname')";
486 final String unionPart = 486 final String unionPart =
487 // add time date functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y) 487 // add time date functions which are not listed in sys.functions but implemented in the SQL parser (see sql/server/sql_parser.y)
488 " UNION SELECT 'extract'" + 488 " UNION SELECT 'extract'" +
489 " UNION SELECT 'now'"; 489 " UNION SELECT 'now'";
490 // ToDo: from release 11.47.1 we also support functions: dayname and monthname, but only with odbc escape notation, so {fn dayname(current_date)}. Related issue: 7300. 490 // ToDo: from release 11.47.1 we also support functions: dayname and monthname, but only with odbc escape notation, so {fn dayname(current_date)}. Related issue: 7300.