Last updated on
Apr 27, 2021 05:39:05 AM GMT
|
Also Applies to ColdFusion
Description
Creates an ODBC date-time object.
Returns
A date-time object, in ODBC timestamp format.
Category
Function syntax
CreateODBCDateTime(date)
See also
CreateDateTime, CreateODBCDate, CreateODBCTime, Now; Evaluation and type conversion issues in Data type conversion in the Developing ColdFusion Applications
Parameters
Parameter |
Description |
|---|---|
date |
Date-time object in the range 100 AD-9999 AD. |
Usage
When passing a date-time value as a string, enclose it in quotation marks. Otherwise, it is interpreted as a number representation of a date-time object.
Example
<cfscript>
year = 2018;
month = 11;
day = 02;
hour = 1;
minute= 09;
second= 46;
myDate=CreateDateTime(year,month,day,hour,minute,second)
format=CreateODBCDateTime(myDate)
writeOutput("Date and time format is : " & format);
</cfscript>
Output
Date and time format is : {ts '2018-11-02 01:09:46'}
Sign in to your account