Skip to main content
L
lands1ide
Inspiring
September 15, 2006
Answered

Timestamp Help needed

  • September 15, 2006
  • 1 reply
  • 280 views
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.
This topic has been closed for replies.
Correct answer lands1ide
I am using a access database with Javascript.

1 reply

E
Eiolon
Known Participant
September 15, 2006
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.
L
lands1ideAuthorCorrect answer
Inspiring
September 15, 2006
I am using a access database with Javascript.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices