user1995781
Reputation: 19453
Get Date Range From MySQL database
How can I get the date range like month and year of the data from MySQL database? For example if a table in database has the record of data from Feb 2012 to Jan 2013, how can I get to know the date range of stored data record?
Upvotes: 0
Views: 152
Answers (1)
Travis G
Reputation: 1602
use the query
select min(date_column), max(date_column) from your_table
Upvotes: 2
Related Questions
- Query Between Date Range Mysql Php
- Getting records from range of dates from MYSQL - PHP
- PHP get all dates in a range from sql
- MySQL querying date range
- How to select date range in mysql?
- SQL selecting date range
- Getting rows between date range in mysql
- php - select from mysql table column between date range
- Date Range Query MySQL
- PHP mysql select date range