SQL Dump for testing date query
These SQLs are created considering today's date as base. So you can take a fresh copy from here ( every day ) and use the same to test your query.
Use the below query to create table in MysQL workbench or PHPMyAdmin and add records for duration ( + and - )370 days from today.
Use this to add records for query in the range of 3 months to 12 months.
Table with date and time dt_table_tm
This article is written by plus2net.com team.
▼ More on Date & Time functions in SQL