CreateODBCTime

Description

Returns a time object in ODBC time format.

Syntax

CreateODBCTime(date)

Parameters

Parameter

Description

date
Date/time object in the period 100 AD-9999 AD

Parameter	Description
date	Date/time object in the period 100 AD-9999 AD

Usage

When passing a date/time value as a string, enclose it in quotes. Otherwise, it is interpreted as a number representation of a date/time object.

Example

<!--- 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>