First of all, store date, time and datetime values as such; numbers that contain either the count of days or the count of seconds starting at 1960-01-01:00:00:00 or midnight (in case of pure time). Then, whenever you need it, use the appropriate format to display the values as wanted. In your case, this would be either YYMMDD10. or DDMMYY10. ... View more