# CreateODBCTime

Returns a time object in ODBC time format.

See also CreateODBCDateTime and CreateTime.

### Syntax

    CreateODBCTime(date)

##### date

Date/time object in the period from 100 AD to 9999 AD.

### Usage

When passing a date/time value as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date/time object, returning undesired results.

### Examples

    <!--- This code illustrates CreateTime and CreateODBCTime --->
    <HTML>
    <HEAD>
    <TITLE>
    CreateODBCTime Example
    </TITLE>
    </HEAD>

    <BODY BGCOLOR=silver>
    <H3>CreateODBCTime Example</H3>

    <CFIF IsDefined("FORM.hour")>
    Your time value, presented using different CF time functions:
    <CFSET yourTime = CreateTime(FORM.hour, FORM.minute, FORM.second)>

    <CFOUTPUT>
    <UL>
        <LI>Built with CreateTime: #TimeFormat(yourTime)#
        <LI>Built with CreateODBCTime: #CreateODBCTime(yourTime)#
    </UL>

    <P>The same value can be formatted with timeFormat:
    <UL>
        <LI>Built with CreateTime: #TimeFormat(yourTime, 'hh:mm:ss')#
        <LI>Built with CreateODBCTime:
           #TimeFormat(yourTime, 'hh:mm:sstt')#
    </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>
    </BODY>
    </HTML>