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
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.
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)#
       <li>day: #DatePart("d", todayDate)#
       <li>weekday: #DatePart("w", todayDate)#
       <li>week: #DatePart("ww", todayDate)#
       <li>hour: #DatePart("h", todayDate)#
       <li>minute: #DatePart("n", todayDate)#
       <li>second: #DatePart("s", todayDate)#
    </ul>
    </cfoutput>

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.