I use phpMyAdmin with a Remote server using mySQL.
I tried using the date option as one of the fields for the first time. I read a little into it first. I used datetime and for the default it added 0000-00-00 00:00:00.
I set it up on my site but a time or date did not appear in the table when data was inserted in the form.
How do I get the date to appear. All that appeared was my name - jason and under date - 0000-00-00 00:00:00 appeared.

Who's time would it be anyway. Would it be the time and date of the server or the browser?

thanks

jason

You can have mysql auto insert the current timestamp if you set the default to CURRENT_TIMESTAMP or when you do an insert or update, you can call NOW() which is a mysql function for inserting the current timestamp. These methods will automatically be formatted by what the field needs.

The timestamp returns the Unix timestamp GMT which is Unix Epoch (January 1st, 1970) so it will need to be adjusted for the timezone offset for your target time if your want to display it to your users.

Issue solved. I first changed one of the settings to current_timestamp but it still did not work thenI was just playing around with it. I tried changing not null to null and now it works. way hay! (thanks for the help mgraphic)

The one last problem is the date come out as '2006-09-06 16:54:21' is there any way to swop the day month and year around?

This is the perferred format for sql to store the datetime stamp, because it will always sort in correct order. You can certainly reformat it once you pull it from the db, or store it as a varchar field, but you would lose all benifits of the sql datetime functions cause it would not see it as datetime.

sorry. one last problem.

The time and date given is incorrect by a number of hours. My guess is that the time is taken from the remote server which is in California and i'm in England. Is there anyway of adding the browswer time?

Details i've added in phpmyadmin -

Field | type |Lenght/Values| Attributes | Null | Default
---------------------------------------------------------------------------------------------------
Time | timestamp | |on update current_timestamp| null |(I ticked
Current_timestamp)