[
https://issues.apache.org/jira/browse/EMPIREDB-269?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16325976#comment-16325976
]
jan commented on EMPIREDB-269:
------------------------------
{code:java}
postgres=# SELECT CURRENT_DATE();
ERROR: syntax error at or near "("
LINE 1: SELECT CURRENT_DATE();
^
postgres=# SELECT CURRENT_DATE;
current_date
--------------
2018-01-15
(1 row){code}
> DBDatabaseDriverPostgreSQL: wrong SQLPhrase for DBSystemDate
> ------------------------------------------------------------
>
> Key: EMPIREDB-269
> URL: https://issues.apache.org/jira/browse/EMPIREDB-269
> Project: Empire-DB
> Issue Type: Bug
> Components: Core
> Affects Versions: empire-db-2.4.6
> Reporter: jan
> Assignee: jan
> Priority: Major
> Fix For: empire-db-2.4.7
>
>
> SQL_CURRENT_DATE returns CURRENT_DATE(), but CURRENT_DATE is correct (at
> least since PostgrSQL 9.3
> ([https://www.postgresql.org/docs/9.3/static/functions-datetime.html)] and in
> current (10.1):
> https://www.postgresql.org/docs/current/static/functions-datetime.html)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
