MySQL Forums
Forum List  »  General

Re: Compound Join Condition Within Same Table - How do you do this?
Posted by: Peter Brawley
Date: April 29, 2020 05:54AM

MySQQL date storage format is yyyy-mm-dd. Values like "28/04/2020" suggest you're storing dates in Varchar columns so date arithmetic doesn't work with them.

Let's see the result of ...

Show Create Table rent;

... and a few sample data rows.

Options: ReplyQuote


Subject
Written By
Posted
Re: Compound Join Condition Within Same Table - How do you do this?
April 29, 2020 05:54AM


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.