How to get a part from a date value in ColdFusion

DatePart() - get a part from a date value

DatePart.cfm


<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>DatePart function example: how to get a part from a date value</title>
</head>

<body>
<h2 style="color:hotpink">DatePart Function Example</h2>

<cfset MyDate=Now()>

<cfoutput>
<b>
MyDate: #MyDate#
<br /><br />
</b>
</cfoutput>
<table style="color:LightGreen; background:Green;" border="1" bordercolor="DarkGreen">
    <tr>
     <td style="font-weight:bold">DatePart</td>
     <td style="font-weight:bold"></td>
     <td style="font-weight:bold">Output</td>
    </tr>
    <tr>
     <td>#DatePart("yyyy",MyDate)#</td>
     <td>Years</td>
     <td><cfoutput>#DatePart("yyyy",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("q",MyDate)#</td>
     <td>Quarter</td>
     <td><cfoutput>#DatePart("q",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("m",MyDate)#</td>
     <td>Month</td>
     <td><cfoutput>#DatePart("m",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("y",MyDate)#</td>
     <td>Day of Year</td>
     <td><cfoutput>#DatePart("y",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("w",MyDate)#</td>
     <td>Weekday</td>
     <td><cfoutput>#DatePart("w",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("ww",MyDate)#</td>
     <td>Week</td>
     <td><cfoutput>#DatePart("ww",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("yyyy",MyDate)#</td>
     <td>Years</td>
     <td><cfoutput>#DatePart("yyyy",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("h",MyDate)#</td>
     <td>Hour</td>
     <td><cfoutput>#DatePart("h",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("n",MyDate)#</td>
     <td>Minute</td>
     <td><cfoutput>#DatePart("n",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("s",MyDate)#</td>
     <td>Second</td>
     <td><cfoutput>#DatePart("s",MyDate)#</cfoutput></td>
    </tr>
    <tr>
     <td>#DatePart("l",MyDate)#</td>
     <td>Millisecond</td>
     <td><cfoutput>#DatePart("l",MyDate)#</cfoutput></td>
    </tr>
</table>

</body>
</html>





More ColdFusion examples