Date in MySQL data structure to do subtraction operation, finally can let me get the value of the year as a new attribute in my set up on the view, bosses help children

CodePudding user response:

Themselves to baidu ah, such a simple thing, is worth Posting?

CodePudding user response:

Create a view, which is used to select statement date function is ok, you can learn baidu date function;
The implementation code:

 select *, year (datet) as year, month (datet) as the month, day (datet) as day from a