php mysql - phpmyadmin DATE

Question

i'm new to databases. I have just created my first database, so far so good. Now I looking to add time in to this.

I have certain table, when it's displayed I need it to show the table info + the date that info was added. Also possible the difference in between (5day 5hours ago) or something of the sort.

Do i need to add another column to the data table where the time will be stored? If so is there a way to auto increment that to current date? How do I go about doing that?

Not really sure where to start can someone please point me in the right direction perhaps a tutorial somewhere? Cant seem to find anything solid on this topic

Thanks a bunch!:)

"If so is there a way to auto increment that to ..." ? what do you want to say not clear — user319198
– user319198, Commented Mar 20, 2012 at 22:04
dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html — Marcus Adams
– Marcus Adams, Commented Mar 20, 2012 at 22:08

haltabush · Accepted Answer · 2012-03-20 22:33:15Z

2

For each record in your DB, you want to know when it has been created?

You have to add a column of type "timestamp". You can then set the default to "current_timestamp". Note also that you can use the "on update current_timestamp". Instead of saving current time on insertion, it will do so each time your record is updated. If you need the 2 dates (created_at and updated_at), you'll need 2 columns. EDIT : well you can't :p

edited Mar 20, 2012 at 22:33

answered Mar 20, 2012 at 22:09

haltabush

4,5382 gold badges26 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Marcus Adams Over a year ago

Don't forget the underscore in CURRENT_TIMESTAMP. It's required. :)

Ben English Over a year ago

You also are restricted from to only one timestamp fields with one of the special default values.

One TIMESTAMP column in a table can have the current timestamp as the default value for initializing the column, as the auto-update value, or both. It is not possible to have the current timestamp be the default value for one column and the auto-update value for another column.

haltabush Over a year ago

Seriously?! Ooops I didn't know this one. Now I understand why Symfony etc don't use it :s @MarcusAdams, corrected too

Ben English · Accepted Answer · 2012-03-20 22:08:59Z

0

There is a datetime as well as a timestamp field. If you use a timestamp field you can have the field automatically populate with the timestamp of when the row was inserted.

http://dev.mysql.com/doc/refman/5.0/en/datetime.html

http://dev.mysql.com/doc/refman/5.0/en/timestamp-initialization.html

I suggest trying out http://sqlzoo.net/ for a gentle introduction to SQL.

answered Mar 20, 2012 at 22:08

Ben English

3,9382 gold badges26 silver badges33 bronze badges

Collectives™ on Stack Overflow

php mysql - phpmyadmin DATE

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related