SQL Database Timestamp

Question

I have a database where people register on a website and their form data then gets inserted into their database. Along with all that information, I want to insert the time of their registration. For example I have an auto-incrementing ID column which I do nothing in my php script for, the sql database automatically increments that with every new entry. In the same way, can I have a time column that I don't have to do anything in the script for, rather the database will just get the current time and put that along with the other inserted information? I'm using phpMyAdmin and I tried adding a column named Time with the type as DATETIME and the default value as the CURRENT_TIMESTAMP but it woulnd't let me add that and said invalid default value for Time.

Ryan Brodie · Accepted Answer · 2012-11-15 20:51:51Z

2

Change the column type to TIMESTAMP.

answered Nov 15, 2012 at 20:51

Ryan Brodie

6,6308 gold badges42 silver badges58 bronze badges

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

Comments

Marc B · Accepted Answer · 2012-11-15 20:51:59Z

1

Use a timestamp field, which does exactly what you want.

answered Nov 15, 2012 at 20:51

Marc B

362k44 gold badges433 silver badges508 bronze badges

Comments

mychalvlcek · Accepted Answer · 2012-11-15 20:55:39Z

1

use timestamp column type e.g.

`inserted` timestamp NOT NULL default CURRENT_TIMESTAMP

answered Nov 15, 2012 at 20:55

mychalvlcek

4,0762 gold badges23 silver badges36 bronze badges

Collectives™ on Stack Overflow

SQL Database Timestamp

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related