Problem with SQL query in visual studio 2013

Question

0.00/5 (No votes)

See more:

SQL

SELECT COUNT(id)
FROM tableA
WHERE DATE(getdate) = '2016-08-14'

The getdate datatype is datetime but right now I only want date only.

The error that I got is

Error in WHERE clause near '('.
Error in WHERE clause near ' '.
Unable to parse query text.

What I have tried:

I have tried using all the solution here but it still not working
http://stackoverflow.com/questions/6119369/simple-datetime-sql-query[^]

Posted 7-Oct-16 20:35pm

Member 12154788

Updated 8-Oct-16 3:57am

Patrice T

v6

Add a Solution

Comments

Maciej Los 8-Oct-16 5:30am

What database: SQL server, MySQL, PostgreSQL, Oracle?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2016-10-08T03:57:00

Solution 2

Assuming Microsoft SQL Server, try something like this:

SQL

DECLARE @TheDate date = '20160814';

SELECT COUNT(id)
FROM tableA
WHERE getdate >= @TheDate
AND getdate < DateAdd(day, 1, @TheDate);

Posted 8-Oct-16 3:57am

Richard Deeming

Patrice T · Answer 2 · 2016-10-07T20:51:00

Solution 1

If you look at this link http://www.w3schools.com/sql/sql_dates.asp[^] , you will see that your date as a string is in wrong format.
try: 2016-10-08

Site to help you to learn SQL: http://www.w3schools.com/sql/default.asp[^]

[Update]
You should learn SQL properly !
getdate and GETDATE() are not the same thing !
http://www.codeproject.com/script/Answers/Post.aspx?aid=1137143[^]

Posted 7-Oct-16 20:51pm

Patrice T

Updated 7-Oct-16 22:26pm

v2

Comments

Member 12154788 8-Oct-16 4:01am

i have tried but not working

David_Wimbley 8-Oct-16 10:31am

Instead of saying "i have tried but not working" you should indicate what is not working and what you expect it to do. If you want help, explain things clearly so those that are willing can help you understand your issue.

Right now GETDATE() is pretty self explanatory. SELECT GETDATE().