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

DateAddDateConvert

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, 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> 
<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>

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy