troubleshooting Question

DATETIME get, today, yesterday, last week, last year

Avatar of Azurewave
Azurewave asked on
MySQL Server
1 Comment1 Solution6483 ViewsLast Modified:
Hiya I have a table with a column called "joined", this is a DATE field and another table with DATETIME.

I will be doing a PHP switch to get each type, so I will do a different query for each type of search.

I am looking for the following:

This Week
This Month
This Year
Last Week
Last Month
Last Year
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros