Same table created by different users in same database have different date format ie. One has YYYY-MM-DD and other YY/MM/DD.
Is this due to table def stored on a different AMP with different date format setting at database level.
SHOW TABLE command can show the format of date columns for a table. For each table it is the same on all AMPs.
Another story is that when users selects data from the table, then the format can change according to regional settings on the client side (depends on the client software).