1. Home
2. php - SQL DATEDIFF with WHERE or BETWEEN operator

881 votes

1 answers

php - SQL DATEDIFF with WHERE or BETWEEN operator

Get the solution ↓↓↓

I am working on mysql query statement. I have to find day difference between two date. Date one is from my table column and date two is now(). And I need to compare output date must be in a day range like 50 to 80. I have tried with two line below code. But both are not working. Any please can help ..

SELECT DATEDIFF(DAY, '2012-01-01', GETDATE()) AS d WHERE d>50 AND d<80

SELECT DATEDIFF(DAY, '2012-01-01', GETDATE()) AS d WHERE d BETWEEN 50 AND 80

Copy code

Undefined asked

2021-12-1

Write your answer

---

939

votes

Answer

Solution:

Thefrom clause cannot use aliases defined in theselect clause. You need to repeat the expression, or use a subquery or cte.

If you are running SQL Server (as your code suggests):

select datediff(day, '2012-01-01', getdate()) as d 
from ...  -- you should have a "from" clause
where datediff(day, '2012-01-01', getdate()) between 50 and 80
Copy code

In MySQL (as the tag on your question indicates):

select datediff(current_date, '2012-01-01') as d 
from ...
where datediff(current_date, '2012-01-01') between 50 and 80
Copy code

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-12-1

Link To Source
Link To Answer People are also looking for solutions of the problem: unable to determine current zabbix database version: the table "dbversion" was not found.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

639 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

201 php,mysql,html - Display SQL query(conjunction) properly in HTML

164 php - Use mysql_fetch_array() with foreach() instead of while()

546 Print informative, well formatted mysql errors in PHP

92 php - File format or extension invalid PHPExcel

275 PHP/MySQL - any shorthand equivalent for PDO UPDATE?

533 PHP: Connect to a MS SQL Server with Dynamic Port Allocation

191 php - Database Error mysqli_init()

694 php - More efficient way to grab MySQL row populated with single value

355 php - Cakephp 2.8.4 ignoring hasMany

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/