Avatar of kvnsdr
kvnsdr asked on

MSSQL to MySQL Datediff minute max conversion?

Me again, this time attempting to understand MySQL's version of Datediff, help...

I suspect Datediff and Interval come into play here somehow...

[MSSQL]
Select col1, count(*) as count1
From table1
Where col1 Like '%Mrs%' Or col1 Like '%Mr%'
group by col1
having datediff(minute, max(colDateTime), getdate()) > '20'
MySQL Server

Avatar of undefined
Last Comment
kvnsdr

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Paulo Pimenta

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
kvnsdr

You're solution didn't error, but also didn't return any results.

So far my new solution is working fine:

Select col1, count(*) as count1
From table1 Where col1 Like '%Mrs%' Or col1 Like '%Mr%'
And datediff(table1.colDateTime, Now()) > '20'
Group By col1
SOLUTION
Paulo Pimenta

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
kvnsdr

Thanks for the clarification...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck