|Pathologically Eclectic Rubbish Lister|
(OT) parsing time in mysqlby sulfericacid (Deacon)
|on Aug 11, 2006 at 21:08 UTC||Need Help??|
sulfericacid has asked for the
wisdom of the Perl Monks concerning the following question:
This was partially discussed in the CB earlier this morning but thought the idea would be easier if there were some examples.
I have a column "time" with timestamps that look like 2006-08-10 10:48:21. I need to select them based on TODAY, THIS WEEK, THIS MONTH, etc.
I am currently using CURDATE(),INTERVAL $by ($by: 1 day, 7 day, etc) which I could probably get by with but it's not quite right. I don't want a "past 24 hours" select, I want a select from today since midnight. On the same token, I don't want the past 7 days, I want this week from Sunday. Same goes for the current month and year.
Selecting an interval on 1 year or even 365 days brings back a year from the current date, not the year of 2006.
I'm looking for non-modular solutions on how this could be pieced together.
"Age is nothing more than an inaccurate number bestowed upon us at birth as just another means for others to judge and classify us"