I have just setup my very first SQL database and it works, hurra !!!
However, I cannot upload a date field from my ASP-page to the corresponding date field in my MySQL database.
I am retrieving the date on my ASP-page with the command 'now()' in the dd-mm-yyyy format. I then want to push the data to my database field (data type: 'DATE') but I can see that MySQL only accepts date formats as yyyy-mm-dd.
Is there an easy way out or do I have to manually rearrange the date format?