when creating a table with a "date" field, how do i change the format of the date (to DD-MM-YYYY)??
the code I've got at the moment is as follows:
Create table sales
any ideas how i'm supposed to do this? (it doesn't like the above code..)