Description
Extracts a part from a date value.
Returns
Part of a date, as an integer.
1 | DatePart("datepart", "date") |
See also
History
ColdFusion MX 6.1: Added the datepart character L or l to represent milliseconds.
Parameters
Parameter |
Description |
|---|---|
datepart |
String:
|
date |
Date/time object, in the range 100 AD-9999 AD. |
Usage
When passing a date/time object as a string, enclose it in quotation marks. Otherwise, it is interpreted as a numeric representation of a date/time object.
Example
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | <!--- 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> <li>quarter: #DatePart("q", todayDate)#</li> <li>month: #DatePart("m", todayDate)#</li> <li>day of year: #DatePart("y", todayDate)#</li> <li>day: #DatePart("d", todayDate)#</li> <li>weekday: #DatePart("w", todayDate)#</li> <li>week: #DatePart("ww", todayDate)#</li> <li>hour: #DatePart("h", todayDate)#</li> <li>minute: #DatePart("n", todayDate)#</li> <li>second: #DatePart("s", todayDate)#</li> </ul> </cfoutput> |
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.