Alternatively you could design your date fields as VARCHAR(10) and format them any way you wish. Of course that would completely negate the extreme usefulness of the DATETIME type and would be a very poor design choice. DATETIME and SMALLDATETIME exist as they are for very good reasons.