Date format

[mhoward]

What is the best format to use for a date when entering into a MySQL database?

I am writing a domain registration script and all the info goes into my database. I want to enter the date that the domain was registered and also the date it is up for renewal.

The renewal date should obviously be calculated by my PHP script, but I don't know the best way of doing it.

[eoghain]

Let MySQL handle it for you. I believe that there is a now(), or similar, function in MySQL that you can use to enter todays date/time. There should also be functions to add time to a date just build your SQL to use these functions when entering the date.