User Guide
720 Chapter 3: ColdFusion Functions
Parameters
Usage
When passing a date/time value as a string, you must enclose it in quotation marks. Otherwise, it
is interpreted as a number representation of a date/time object.
Database query results for date and time values can vary in sequence and formatting unless you
use functions to format the results. To ensure that dates and times display with appropriate
formatting, and that users of your ColdFusion application are not confused by dates and times
displayed, Macromedia recommends that you use the
DateFormat and TimeFormat functions to
format date and time values from queries. For more information and examples, see TechNote
22183, "ColdFusion Server (5 and 4.5.x) with Oracle: Formatting Date and Time Query Results," at
www.coldfusion.com/Support/KnowledgeBase/SearchForm.cfm.
Example
<cfset todayDate = #Now()#>
<body>
<h3>TimeFormat Example</h3>
<p>Today’s date is <cfoutput>#todayDate#</cfoutput>.
<p>Using Timeformat, we can display the value in different ways:
<cfoutput>
<ul>
<li>#TimeFormat(todayDate)#
<li>#TimeFormat(todayDate, "hh:mm:ss")#
<li>#TimeFormat(todayDate, "hh:mm:sst")#
<li>#TimeFormat(todayDate, "hh:mm:sstt")#
<li>#TimeFormat(todayDate, "HH:mm:ss")#
</ul>
</cfoutput>
</body>
Parameter Description
time A date/time value or string to convert
mask Masking characters that determine the format:
•
h: Hours; no leading zero for single-digit hours (12-hour clock)
•
hh: Hours; leading zero for single-digit hours (12-hour clock)
•
H: Hours; no leading zero for single-digit hours (24-hour clock)
•
HH: Hours; leading zero for single-digit hours (24-hour clock)
•
m: Minutes; no leading zero for single-digit minutes
•
mm: Minutes; a leading zero for single-digit minutes
•
s: Seconds; no leading zero for single-digit seconds
•
ss: Seconds; leading zero for single-digit seconds
•
l: Milliseconds
•
t: One-character time marker string, such as A or P
•
tt: Multiple-character time marker string, such as AM or PM
• short: equivalent to h:mm tt
• medium: equivalent to h:mm:ss tt
• long: medium followed by three-letter time zone; as in, 2:34:55 PM EST
• full: same as long