the default value for date dataype is '0000-00-00'.



got any query that can change the default value from '0000-00-00' into '00/00/0000' or 'mm/dd/yyyy' ?



any help, i truly appraciated it.

thanks