Parameter
Last updated on
Sep. 15, 2022
|
Also applies to ColdFusion
Description
Creates a date-time object.
Returns
A date/time value.
Category
Function syntax
CreateDateTime(year, month, day, hour, minute, second, millisecond)
History
Introduced in ColdFusion MX6.
See also
CreateDate, CreateTime, CreateODBCDateTime, Now; Evaluation and type conversion issues in Data type conversion in the Developing ColdFusion Applications
Parameters
Parameter |
Description |
|---|---|
year |
Integer in the range 0-9999. Integers in the range 0-29 are converted to 2000-2029. Integers in the range 30-99 are converted to 1930-1999. You cannot specify dates before AD 100. |
month |
Integer in the range 1 (January) - 12 (December) |
day |
Integer in the range 1 - 31 |
hour |
Integer in the range 0 - 23 |
minute |
Integer in the range 0 - 59 |
second |
Integer in the range 0 - 59 |
| millisecond | Integer in the range 0-999 |
In Adobe ColdFusion (2016 release), you can use the CreateDateTime function in the following ways:
- CreateDateTime(year)
- CreateDateTime(year, month)
- CreateDateTime(year, month, day)
- CreateDateTime(year, month, day, hour)
- CreateDateTime(year, month, day, hour, minute)
- CreateDateTime(year, month, day, hour, minute, second)
- CreateDateTime(year, month, day, hour, minute, second, millisecond)
|
|
Default value |
|
Month |
1 |
|
Day |
1 |
|
Hour |
0 |
|
Minute |
0 |
|
Second |
0 |
If you pass the parameter values only partially, other fields take the default value. For example, CreateDateTime(2016) produces '2016-01-01 00:00:00', where 2016 is the specified parameter and the rest are produced by default.
Example #1
<cfscript>
// Create date time object and display it
WriteOutput(CreateDateTime(2016,2,16,16,45,34) & " | "); // Create object for specified time
WriteOutput(#now()#); // Create object for now()
</cfscript>
Output
{ts '2016-02-16 16:45:34'} | {ts '2016-03-14 13:15:31'}
Example #2
<cfscript>
// In ColdFusion (2016 release), you can use the CreateDateTime in the following ways
WriteOutput(CreateDateTime(2016) & " | ");
WriteOutput(CreateDateTime(2016,6) & " | ");
WriteOutput(CreateDateTime(2016,6,10) & " | ");
WriteOutput(CreateDateTime(2016,6,10,17) & " | ");
WriteOutput(CreateDateTime(2016,6,10,17,45) & " | ");
WriteOutput(CreateDateTime(2016,6,10,17,45,38));
</cfscript>
Output
{ts '2016-01-01 00:00:00'} | {ts '2016-06-01 00:00:00'} | {ts '2016-06-10 00:00:00'} | {ts '2016-06-10 17:00:00'} | {ts '2016-06-10 17:45:00'} | {ts '2016-06-10 17:45:38'}
<cfscript>
year = 2018;
month = 11;
day = 02;
hour = 1;
minute= 09;
second= 46;
myDate=CreateDateTime(year,month,day,hour,minute,second)
writeOutput("The date and time is: " & myDate);
</cfscript>
Output
The date and time is: {ts '2018-11-02 01:09:46'}
<cfscript>
myVar = createDateTime(2022,9,15,1,32,59,999);
writeOutput(myVar & "<br/>");
writeOutput("From millisecond(DateTime)" & "<br/>")
writeOutput(#millisecond(myVar)#);
writeOutput("<br/>")
writeOutput("From millisecond(DateTime)" & "<br/>")
writeOutput(#myVar.millisecond()#);
</cfscript>
Output
{ts '2022-09-15 01:32:59'}
From millisecond(DateTime)
999
From millisecond(DateTime)
999