The date virtual will convert the format of an existing date column in the table. For example, when a date is held in a real column in format YYMMDD it can be easily mapped into a virtual column in format DDMMYY. The real column may be the most commonly used format for ordering the table, but the virtual column format may be the most commonly used for display or printing.
Refer to:
Also See
