SfC Home > Web Design > SQL > ColdFusion >

Mini-Quiz: Dealing with Dates and Times in ColdFusion

by Ron Kurtus

Take this Mini-Quiz to check your understanding of the lesson material.

---

---

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

Use the DateFormat function

Use Validation

Use the CreateODBCDateTime function

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

You must use CFINPUT

You can't account for Daylight Savings Time

It uses a 24 hour clock

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

You need to first convert to ODBC format and then update per field

CFUPDATE only works with whole numbers

You can use it for dates but not times

If you got all three correct, you are on your way to becoming a Champion in ColdFusion Development. If you had problems, you had better look over the material again.

---

Seek to better society with your work

---

Resources and references

Ron Kurtus' Credentials

Websites

ColdFusion Resources

Books

(Notice: The School for Champions may earn commissions from book purchases)

Top-rated books on ColdFusion

---

Questions and comments

Do you have any questions, comments, or opinions on this subject? If so, send an email with your feedback. I will try to get back to you as soon as possible.

---

Share this page

Click on a button to bookmark or share this page through Twitter, Facebook, email, or other services:

---

Students and researchers

The Web address of this page is:
www.school-for-champions.com/coldfusion/
mini-quiz_dates.htm

Please include it as a link on your website or as a reference in your report, document, or thesis.

Copyright © Restrictions

---

Where are you now?

School for Champions

ColdFusion topics

Mini-Quiz: Dealing with Dates and Times

---

---

---

ColdFusion topics

Basics

• Overview of Adobe ColdFusion

Development methods

• ColdFusion Development Steps

Specific applications

• Query Database
• Using Session Variables
• Combining Form and Action Pages
• Using Drop-Down Lists
• Converting ColdFusion to PDF
• Dealing with Dates and Times
• Sending Flash with ColdFusion Email
• Changing Data to Telephone Format
• Populating New Database from Old
• Populating a Matrix Table
• Sorting a Table Listing in ColdFusion
• List Ten-at-a-Time from a Query

Also see

• ColdFusion Survey Results
• Using SQL
• Flash Development
• Website Design

---

---

Let's make the world a better place

Be the best that you can be.

Use your knowledge and skills to help others succeed.

Don't be wasteful; protect our environment.

You CAN influence the world.

---

---

---

---

Live Your Life as a Champion:

Take care of your health

Seek knowledge and gain skills

Do excellent work

Be valuable to others

Have utmost character

Be a Champion!

---