Interested to Buy Any Domain ? << Click Here >> for more details...
How can we know the number of days between two given dates
using MySQL?
- 2 Answers
- 7684 Views
- Base2 Infotech, Webworks, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sergii
DATEDIFF(expr1,expr2)
DATEDIFF() returns expr1 – expr2 expressed as a value in
days from one date to the other. expr1 and expr2 are date
or date-and-time expressions. Only the date parts of the
values are used in the calculation.
mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');
-> 1
mysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');
-> -31
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / shwetha
There is a operator {not} BETWEEN ,we can use this in where
clause to get in between dates.
ex:
select count(column name)
from table1
where dates BETWEEN '01-jul-04' and '01-jul-05';
| Is This Answer Correct ? | 4 Yes | 4 No |
How to use sum function in where clause in mysql?
How to make a column bigger and delete unique from table.
What is deterministic in mysql?
What is field in mysql?
How many rows can mysql hold?
What are the types of database engines available in mysql?
what are the different tables present in mysql? : Mysql dba
How to use mysqldump to create a copy of the database?
What is innodb_buffer_pool_size?
How do I change directories in mysql?
What is a definer?
How to change the database engine in mysql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
