how to changing default '-' character in Datetime in MySQL?

[Rajeev Prasad]

Hello,

MySQL datetime field type keeps data as: YYYY-MM-DD HH:mm:SS 


is there a way to store this data as: YYYY/MM/DD HH:mm:SS

or going much further (optionally) can we store as: MM/DD/YYYY HH:mm:SS  ?


  if not then whats the best way to reformat the cell value from YYYY-MM-DD to
MM/DD/YYY

ty
Rajeev