php - Store and display the date of registration of a user

问题描述:

I am making a registration form with 8-10 fields. Apart from this I have 2 other fields in my database, userid which is a primary key wioth auto incrementation and an active field, whether the user is active or not. But I want to add one more field, that is the registration date and store it in IST (Indian Standard Time)

When I click my profile link in stackoverflow, I see that I have registered X months back and I have visited the site X number of times. I want to add a similar feature to the profile of my users which displays the exact date and time when they were registered! Ex, member since: 28/7/2001! Something like that.

Do I have to do any tweak in my registration form? Or do I have to do any other thing? I searched on google and stackoverflow for the same, searched the php and mysql documentation too, saw a lot of things about dates and timestamps but I don't know how to go about, didn't get exactly what I wanted and wasn't convinced enough. Please help me solve this problem.