User Guide

434 Chapter 3: ColdFusion Functions
CreateODBCTime
Description
Creates an ODBC time object.
Returns
A time object, in ODBC timestamp format.
Category
Date and time functions
Function syntax
CreateODBCTime(date)
See also
CreateODBCDateTime, CreateTime
Parameters
Usage
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.
Example
<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>
Parameter Description
date Date/time object in the range 100 AD–9999 AD.