Creates an ODBC time object.
A time object, in ODBC timestamp format.
CreateODBCTime(date
)
CreateODBCDateTime, CreateTime, "Evaluation and type conversion issues" in the ColdFusion Developer's Guide
Parameter |
Description |
---|---|
date |
Date/time object in the range 100 AD-9999 AD. |
When passing a date-time value as a string, you must enclose it in quotation marks. Otherwise, it is interpreted as a number representation of a date-time object.
<h3>CreateODBCTime Example</h3> <CFIF IsDefined("form.hour")> Your time value, created with CreateTime... <CFSET yourTime = CreateTime(form.hour, form.minute, form.second)> <cfoutput> <ul> <li>Formatted with CreateODBCTime: #CreateODBCTime(yourTime)# <li>Formatted with TimeFormat: #TimeFormat(yourTime)# </ul></cfoutput> </CFIF> <CFFORM action="createodbctime.cfm" METHOD="post"> <PRE> Hour <CFINPUT TYPE="Text" NAME="hour" VALUE="16" RANGE="0,23" MESSAGE="You must enter an hour (0-23)" VALIDATE="integer" REQUIRED="Yes"> Minute <CFINPUT TYPE="Text" NAME="minute" VALUE="12" RANGE="0,59" MESSAGE="You must enter a minute value (0-59)" VALIDATE="integer" REQUIRED="Yes"> Second <CFINPUT TYPE="Text" NAME="second" VALUE="0" RANGE="0,59" MESSAGE="You must enter a value for seconds (0-59)" VALIDATE="integer" REQUIRED="Yes"> </PRE> <p><INPUT TYPE="Submit" NAME=""> <INPUT TYPE="RESET"> </cfform>