How can I resolve this: 12/30/2017 is not valid at this position, expecting EOF, ';'?

Question

I'm trying to write an SQL that calculates the total revenue from 1/2/2017 to 12/30/2017, but it does not recognise the second date. It says invalid position.

SELECT SUM(orderRevenue)
  AS "Total Revenue for 2017"
FROM transactionid
WHERE TransactionDate BETWEEN DATE '1/2/2017' AND DATE '12/30/2017';

Just get rid of `DATE` in both places – Dharman Jan 10 '22 at 01:03 — Dharman, Jan 10 '22 at 01:03
take note of the date format too -`YYYY-MM-DD` – danblack Jan 10 '22 at 01:05 — danblack, Jan 10 '22 at 01:05

score 1 · Answer 1 · answered Jan 10 '22 at 01:04

1

You just need to use the correct date format -

SELECT SUM(orderRevenue) AS `Total Revenue for 2017`
FROM transactionid
WHERE TransactionDate BETWEEN '2017-01-02' AND '2017-12-30';

answered Jan 10 '22 at 01:04

nnichols

7,403
1
19
26

How can I resolve this: 12/30/2017 is not valid at this position, expecting EOF, ';'?

1 Answers1