DatePart

Description

Returns part of a date as an integer.

Syntax


DatePart(datepart, date)

Parameters

Parameter

Description

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
A date/time object

Parameter	Description
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	A date/time object

Usage

Year values 0 - 29 are interpreted as 21^st century dates. Year values 30 - 99 are interpreted as 20^th century dates.

When passing a date/time value as a string, enclose it in quotes. Otherwise, it is interpreted as a number representation of a date/time object.

Example

<!--- 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>.



<P>Using datepart, we can 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>  



</body>

</html>