View comments | RSS feed
Contents > CFML Reference > ColdFusion Functions > CreateODBCTime PreviousNext

CreateODBCTime

Creates an ODBC time object.

A time object, in ODBC timestamp format.

Date and time functions

CreateODBCTime(date)

CreateODBCDateTime, CreateTime

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>

Contents > CFML Reference > ColdFusion Functions > CreateODBCTime PreviousNext

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.

Comments


p-riddy said on May 25, 2006 at 3:17 PM :
The following code also works:
<cfset time = "4:00 pm">
<cfset test = createOdbcDateTime(time)>
<cfoutput>#test#</cfoutput> <br />

<cfset time = "4:00 am">
<cfset test = createOdbcTime(time)>
<cfoutput>#test#</cfoutput>

This is very helpfull when converting from standard time to military time.

 

RSS feed | Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/coldfusion/6.1/htmldocs/functi51.htm