User Guide

450 Chapter 3: ColdFusion Functions
DatePart
Description
Extracts a part from a date value.
Returns
Part of a date, as an integer.
Category
Date and time functions
Function syntax
DatePart("datepart", "date")
See also
DateAdd, DateConvert
History
ColdFusion MX 6.1: Added the datepart character L or l to represent milliseconds.
Parameters
Usage
When passing a date/time object as a string, you must enclose it in quotation marks. Otherwise, it
is interpreted as a numeric representation of a date/time object.
Example
<!--- This example shows information available from DatePart --->
<cfset todayDate = Now()>
<h3>DatePart Example</h3>
<p>Today’s date is <cfoutput>#todayDate#</cfoutput>.
<p>Using datepart, we extract an integer representing the dateparts from that
value
<cfoutput>
<ul>
<li>year: #DatePart("yyyy", todayDate)#
<li>quarter: #DatePart("q", todayDate)#
<li>month: #DatePart("m", todayDate)#
<li>day of year: #DatePart("y", todayDate)#
Parameter Description
datepart String:
• yyyy: Year
• q: Quarter
• m: Month
• y: Day of year
• d: Day
• w: Weekday
• ww: Week
• h: Hour
• n: Minute
• s: Second
• l: Millisecond
date Date/time object, in the range 100 AD–9999 AD.