I needed to select records for this month so far from the database, which required getting the first day of the...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
current month. After a while, I worked out the following code. To get the prior 12 months, add "- 12 months" after the "+ 1 day" part. select * from file where indate >= date(curdate() - day(curdate()) days + 1 day)
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Visit the ITKnowledge Exchange and get answers to your developing questions fast.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.