MySQL Forums
Forum List  »  MySQL Workbench

SQL Workbench error : "select" is not valid at this position for this server version, expecting: '(', WITH
Posted by: Nikhil Chaudhary
Date: April 02, 2019 06:35AM

I am seeing this error, Tried everything but unable to resolve this. Please help

Query:

SELECT
DATE_FORMAT(created_at, ‘%Y-%m-%d’),
increment_id,
status,
UPPER(coupon_code),
base_subtotal,
base_discount_amount
FROM
hello
WHERE
(created_at BETWEEN ‘2019-03-01 00:00:00’ AND ‘2019-03-31 23:59:59’)

Options: ReplyQuote


Subject
Views
Written By
Posted
SQL Workbench error : "select" is not valid at this position for this server version, expecting: '(', WITH
4672
April 02, 2019 06:35AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.