SQL Dump for testing date & time 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.


  • Video Tutorial on Date Query using CURDATE, BETWEEN , YEAR, MONTH, DAYOFWEEK()


Use this to add records for query in the range of 3 months to 12 months.

Table with date and time dt_table_tm




plus2net.com






Post your comments , suggestion , error , requirements etc here





SQL Video Tutorials










We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2020 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer