Last updated on
Apr 27, 2021 05:39:01 AM GMT
|
Also Applies to ColdFusion
Description
Extracts a part from a date value.
Returns
Part of a date, as an integer.
Category
Function syntax
DatePart(datepart, date)
See also
History
ColdFusion MX 6.1: Added the datepart character L or l to represent milliseconds.
Parameters
Parameter |
Description |
|---|---|
datepart |
String:
|
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
<cfscript>
Date1 = "{ts '2018-11-15 12:13:50'}";
DatePart= DatePart("yyyy",Date1)
DatePart1= DatePart("m",Date1)
DatePart2= DatePart("d",Date1)
DatePart3= DatePart("h",Date1)
DatePart4= DatePart("n",Date1)
DatePart5= DatePart("s",Date1)
writeOutput("year is : " & DatePart & "<br/>")
writeOutput("month is : " & DatePart1 & "<br/>")
writeOutput("day is : " & DatePart2 & "<br/>")
writeOutput("hour is : " & DatePart3 & "<br/>")
writeOutput("minute is : " & DatePart4 & "<br/>")
writeOutput("second is : " & DatePart5 & "<br/>")
</cfscript>
Output
year is : 2018
month is : 11
day is : 15
hour is : 12
minute is : 13
second is : 50
Sign in to your account