SQL Count (*) function with dates

Question

How do I use the count (*) function within a set date parameter? I have a table of order records and I would like to only count the ones for a specific date.

My Query was

SELECT COUNT (*) 
FROM bets
WHERE order_date='2018-01-22';

And that returned this

1 queries executed, 0 success, 1 errors, 0 warnings

cQuery: SELECT COUNT (*) FROM bets WHERE order_date='2018-01-22' LIMIT 0, 1000

Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM bets WHERE order_date='2018-01-22' LIMIT 0, 1000' at line 1

Execution Time : 0 sec Transfer Time : 0 sec Total Time : 0.021 sec

juergen d · Accepted Answer · 2018-01-22 11:56:32Z

4

Remove the space between count and ()

SELECT COUNT(*) ...

answered Jan 22, 2018 at 11:56

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

A.D. · Accepted Answer · 2018-01-22 12:00:27Z

0

The above works in Postgres, mysql needs set sql_mode = "IGNORE_SPACE";.

That why this gives you an error there two way either you can remove space or set sql_mode.

answered Jan 22, 2018 at 12:00

A.D.

2,3722 gold badges17 silver badges25 bronze badges

Comments

Mayank Awasthi · Accepted Answer · 2018-01-22 13:34:14Z

-1

I have tried and mentioned query is working for me:

SELECT count(*) FROM "**TABLENAME**"  where  DATE_FORMAT(**columnName**,'%Y-%m-%d') = '2017-08-02';

answered Jan 22, 2018 at 13:34

Mayank Awasthi

4912 silver badges9 bronze badges

Collectives™ on Stack Overflow

SQL Count (*) function with dates

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related