2. ASPRunnerPro General questions
  3. [SOLVED]  How set a datetime value
This topic is locked
[SOLVED]

 How set a datetime value

 		1/28/2010 9:48:04 AM
ASPRunnerPro General questions
Stu author

I have a SQL field in datetime format and I want to date & timestamp a field when a record is added to a table. I can set that field to a default value but I don't what default value gives me a date and time.
The Visual editor only allows the date OR time format to be displayed so I don't know if I set the field to Now() whether I get the time as well as the date when viewed in SQL server
Thanks
Stu
Stu author 1/28/2010

Whoops!
I can confirm that if you set the DateTime format to the first plain Date Format then Now() DOES stamp the time too!
(Well at least I asked a useful question and gave a useful answer)
Stu