Get data according to date in MySQL

Question

Navigation

#1 by (2 votes)

2

I need to provide the option to view the data according to a time X determined by the user, for example

I want the data from 03/01/2011 to 12/25/2014

How can I do this with MySQL? How do I set the table so everything can work out?

php mysql sql

asked by anonymous 26.12.2014 / 03:33

1 answer

Modify a button's property when closing modal bootstrap Data.frame for ts daily data in R

score 2 · Answer 1

If you have a 'column' of type DATE , you can use the following:

SELECT * FROM table WHERE coluna > '2011-03-01' AND coluna < '2014-12-25'

If 'column' is in DATETIME you can use the following:

SELECT * FROM table WHERE coluna > '2011-03-01 00:00:00' AND coluna < '2014-12-25 00:00:00'

As your database was not specified, this could help. Of course, TIMESTAMP or TIME can be used, but only adapt.