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.

Years from 0 to 29 are interpreted as 21^st century values. Years 30 to 99 are interpreted as 20^th century values.

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>

<FORM action="createodbctime.cfm" METHOD="post">
<INPUT TYPE="hidden" NAME="hour_Required">
<INPUT TYPE="hidden" NAME="minute_Required">
<INPUT TYPE="hidden" NAME="second_Required">
<INPUT TYPE="hidden" NAME="hour_Range" Value="Min=1 Max=24">
<INPUT TYPE="hidden" NAME="minute_Range" Value="Min=1 Max=60">
<INPUT TYPE="hidden" NAME="second_Range" Value="Min=0 Max=60">
<PRE>
Hour    <INPUT TYPE="Text" NAME="hour" VALUE="16">
Minute    <INPUT TYPE="Text" NAME="minute" VALUE="12">
Second    <INPUT TYPE="Text" NAME="second" VALUE="0">
</PRE>
<P><INPUT TYPE="Submit" NAME=""> <INPUT TYPE="RESET">
</FORM>
</BODY>
</HTML>