Search the Community
Showing results for tags 'mysql dates'.
Hi all, I have a set of dates as below: I wish to rearrange / UPDATE these dates in the DB to have a uniform gap between them like that of 1 or 2 or 3 or 0 or n days and a uniform interval of time ( 2 or 3 or 4 or 5 or n hours) between TimeOfLogin and TomeOfLogout. What would be the best way to achieve that? Should I i use php for this or is there an all mysql way to achieve this !! Thanks all !
Hi all I have a datetime field on my database table, and the rows have dates of events over the last hundred years, and I want to somehow order by month and day from todays date but ignore the year, so i guess that is a group by daymonth type thing. the idea being when you hit the page, you will see anything that happend on this day but in any previous years too, and then work backwards in day/months. so say i had 3 dates, a)1st april 2013 b)1 march 2005 c)1st april 2000 the desired order would be a,c,b , if the query was run on 1st april, but if it was run on 1st march the order would be b,a,c. I hope that makes sense. I tried this: GROUP BY DAYOFMONTH(item_date) ORDER BY `item_date` DESC which gets the order correct, but i then need it to associate with current date, so i tried this but it just threw me an empty record set: WHERE DATE(item_date) = DATE(NOW()) GROUP BY DAYOFMONTH(item_date) ORDER BY `item_date` DESC anyone have any pointers or ideas?