MACROMEDIA COLDFUSION MX 61-CFML, Reference

Page: 430 / 806

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.