compare date mysql

njboot

Code: SQL

2021-02-25 18:45:49

SELECT *
FROM players
WHERE DATE(us_reg_date) BETWEEN '2000-07-05' AND '2011-11-10'

slacker

Code: SQL

2021-07-17 23:52:02

Select * From temp where mydate > STR_TO_DATE('2009-06-29 04:00:44', '%Y-%m-%d %H:%i:%s');

Mathematician

Code: SQL

2021-02-25 18:47:29

Select * From temp where mydate > '2009-06-29 04:00:44';

New to Communities?

Join the community