Mini-Quiz: Dealing with Dates and Times in ColdFusion

1. How do you output a date queried from date/time field in a database?

   Use the DateFormat functionThat is correct. You are becoming a ColdFusion Champion. Use ValidationSorry, not correct. Try another button. Use the CreateODBCDateTime functionGood try, but not right. Select another answer.

2. What is wrong with using validation when inputting time through a form?

   You must use CFINPUTSorry, not correct. Try another button. You can't account for Daylight Savings TimeOops! Wrong answer. Re-read the question and try again. It uses a 24 hour clockCorrect. You're improving every day.

3. Why can't you use CFUPDATE with dates or time?

   You need to first convert to ODBC format and then update per fieldThat is correct. You are becoming a ColdFusion Champion. CFUPDATE only works with whole numbersGood try, but not right. Select another answer. You can use it for dates but not timesOops! Wrong answer. Re-read the question and try again.

Pick an answer to see instant feedback. Re-read the lesson if you miss one.