WendyLady Posted September 24, 2006 Share Posted September 24, 2006 Hi all -- I hope you are having a great weekend.If I have dates stored in a unix timestamp, is it possible to do a MySQL query that pulls all dates from a certain month? Do I have to pull all the dates first & then specify the ones I want (seems resource-intensive)?Thanks so much!Wendy Quote Link to comment Share on other sites More sharing options...
obsidian Posted September 24, 2006 Share Posted September 24, 2006 i would just come up with two variables (one for the first day of the month and one for the last), and then you could query for all records beween those timestamps:[code]<?phplist($year, $month, $day) = explode('-', date('Y-m-d'));$first = mktime(0,0,0,$month,1,$year);$last = mktime(0,0,0,$month,date('t'),$year);$sql = mysql_query("SELECT * FROM table WHERE dateCol >= $first AND dateCol <= $last");?>[/code]hope that helps ;) Quote Link to comment Share on other sites More sharing options...
WendyLady Posted September 24, 2006 Author Share Posted September 24, 2006 Thanks so much! I had to tweak it for my particular code, but the concept works beautifully!Thanks again --Wendy Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.