Timestamp Date/Time ASP(Access database)

[ShotokanTuning]

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())%>

<% response.write(now())%>