User Guide

430 Chapter 3: ColdFusion Functions
CreateODBCDate
Description
Creates an ODBC date object.
Returns
A date object, in normalized ODBC date format.
Category
Date and time functions
Function syntax
CreateODBCDate(date)
See also
CreateDate, CreateODBCDateTime
Parameters
Usage
This function does not parse or validate values. To ensure that dates are entered and processed
correctly (for example, to ensure that a day/month/year entry is not confused with a month/day/
year entry, and so on), Macromedia recommends that you parse entered dates with the
DateFormat function, using the mm-dd-yyyy mask, into three elements. Ensure that values are
within appropriate ranges; for example, to validate a month value, use the attributes
validate =
"integer"
and range = "1,12".
Example
<h3>CreateODBCDate Example</h3>
<CFIF IsDefined("form.year")>
<p>Your date value, generated with CreateDateTime:
<cfset yourDate = CreateDateTime(form.year, form.month, form.day, form.hour,
form.minute, form.second)>
<cfoutput>
<ul>
<li>Formatted with CreateDate: #CreateDate(form.year, form.month, form.day)#
<li>Formatted with CreateDateTime:
#CreateDateTime(form.year, form.month, form.day, form.hour, form.minute,
form.second)#
<li>Formatted with CreateODBCDate: #CreateODBCDate(yourDate)#
<li>Formatted with CreateODBCDateTime: #CreateODBCDateTime(yourDate)#
</ul>
<p>The same value can be formatted with DateFormat:
<ul>
<li>Formatted with CreateDate and DateFormat:
#DateFormat(CreateDate(form.year,form.month, form.day), "mmm-dd-yyyy")#
<li>Formatted with CreateDateTime and DateFormat:
#DateFormat(CreateDateTime(form.year, form.month, form.day, form.hour,
form.minute, form.second))#
<li>Formatted with CreateODBCDate and DateFormat:
#DateFormat(CreateODBCDate(yourDate), "mmmm d, yyyy")#
<li>Formatted with CreateODBCDateTime and DateFormat:
#DateFormat(CreateODBCDateTime(yourDate), "d/m/yy")#
Parameter Description
date Date or date/time object in the range 100 AD–9999 AD.