MySQL Select Where date is last day of each month
Posted on 2011-09-23
Hello, I am trying to write a select query in MySQL where I pull data for the last day of every month between a specific range.
Lets say I have a data base called stockPrices with a date (yyyy-mm-dd), Ticker, Price. The data is daily. and I am trying to pull the price for the last trading day of every month between a specific rage of dates.