Creates an ODBC time object.
A time object, in ODBC timestamp format.
CreateODBCTime(date)
CreateODBCDateTime, CreateTime, Evaluation and type conversion issues in Data type conversion in the Developing ColdFusion Applications
Parameter |
Description |
|---|---|
date |
Date/time object in the range 100 AD-9999 AD. |
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.
<cfscript>
year = 2018;
month = 11;
day = 02;
hour = 1;
minute= 09;
second= 46;
myDate=CreateDateTime(year,month,day,hour,minute,second)
format=CreateODBCTime(myDate)
writeOutput("Time format is : " & format)
</cfscript>
Output
Time format is : {t '01:09:46'}
Sign in to your account