If you want date and time you can use the built in function of now() so if you are submitting a form to insert or update make a hidden field with the value being now() so:
hey it is not working i have put it in a form and when i submit this form i get in the database now() not the date ... ??? what shell i do ?
with sql they assign for date as this :
insert into Table_name(date) values (SYSDATE);
how can i change it to use it in the asp .... btw i have another fields to enter ... so please could u find me the way or check if the way u give it to me is working or not ??? thanks a lot