Timestamp Date/Time ASP(Access database)
Hi I'm writing a ASP application which uses a Access database.
I want to make a timestamp everytime a table was updated.
For that I need the current date and the current time to be saved to the databse.
Looking at the Access database default options, I think "General Date" (dd-m-yy hh:mm:ss) is the best option.
- First how do I get the current time, how do I get it in the right format and how do I save it to the database. I thought about Now() or <% =Now %> but how do I use that, in this case.
- Then when the date is in the database how do I show it in a webpage. Can I just write the Table field as if it was ordinairy text?
Thanks alot.
<% response.write(now())%>
VB Code:
<% response.write(now())%>