MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Working with joins
Posted by: Barry Galbraith
Date: August 18, 2017 08:59PM

You need to store your dates in a date field, not a VARCHAR with those horrible US dates.
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
Then you can use the builtin DATE and TIME functions to manipulates your dates.

Good luck,
Barry.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Working with joins
Ebaad Ahmed
August 16, 2017 03:11PM
Re: Working with joins
Barry Galbraith
August 18, 2017 08:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.