Answers for "mysql query date between 2 columns"

SQL
1

mysql query dates between two dates

select * from users 
where signup_date between '2020-05-01' and '2020-12-10 23:59:59';
// Important with the times, 
// otherwize you will not get all records from end date.
// Event if you only have date and no times in signup_date column
Posted by: Guest on December-03-2020
0

mysql make date from 2 column

SELECT * FROM `mytable` WHERE TIMESTAMP(`d`, `t`) > '2012-02-01 15:00'
Posted by: Guest on February-11-2021

Code answers related to "mysql query date between 2 columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language