User Guide
Chapter 2: ColdFusion Functions 327
DatePart
Returns the specified part of a date as an integer.
See also DateAdd and DateConvert.
Syntax DatePart(
datepart
,
date
)
datepart
One of the following strings:
•
yyyy — Year
•
q — Quarter
•
m — Month
•
y — Day of year
•
d — Day
•
w — Weekday
•
ww — Week
•
h — Hour
•
n — Minute
•
s — Second
date
Any date.
Usage Years from 0 to 29 are interpreted as 21
st
century values. Years 30 to 99 are interpreted
as 20
th
century values.
When passing a date/time value as a string, make sure it is enclosed in quotes.
Otherwise, it is interpreted as a number representation of a date/time object, returning
undesired results.
Examples <!--- This example shows information available from DatePart --->
<HTML>
<HEAD>
<TITLE>
DatePart Example
</TITLE>
</HEAD>
<CFSET todayDate = Now()>
<BODY>
<H3>DatePart Example</H3>
<P>Today’s date is <CFOUTPUT>#todayDate#</CFOUTPUT>.