Timestamp Help needed

[lands1ide]

I have a form that goes into a database. How do i add a timestamp to the form and send that timestamp to a record when they hit submit. Thanks.

[Eiolon]

What language are you using?

I generally make a field in my MySQL database called:

submitted TIMESTAMP DEFAULT CURRENT_TIMESTAMP

and then when the user hits submit on the form it will automatically add it.

Be aware that timestamp only goes up to 2037 or something like that. I recommend datetime for anything longterm.

[lands1ide · Accepted solution]

I am using a access database with Javascript.