CreateODBCDateTime

Description

Returns a date/time object in ODBC timestamp format.

Syntax

CreateODBCDateTime(date)

Parameters

Parameter

Description

date
Date/time object in the range 100 AD-9999 AD. Year values 0-29 are interpreted as 21^st century dates. Year values 30-99 are interpreted as 20^th century dates

Parameter	Description
date	Date/time object in the range 100 AD-9999 AD. Year values 0-29 are interpreted as 21^st century dates. Year values 30-99 are interpreted as 20^th century dates

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 example shows how to use CreateDate, CreateDateTime, 
and createODBCDateTime 
----------------------------------------------------------->
<html>
<head>
<title>
CreateODBCDateTime Example
</title>
</head>

<body bgcolor = silver>
<H3>CreateODBCDateTime Example</H3>
<cfif IsDefined("FORM.year")>
Your date value, presented using different CF date functions:
<cfset yourDate = CreateDateTime(FORM.year, FORM.month, FORM.day, 
  FORM.hour, FORM.minute, FORM.second)>
<cfoutput>
<UL>
  <LI>Built with CreateDate:
    #CreateDate(FORM.year, FORM.month, FORM.day)#
  <LI>Built with CreateDateTime:
    #DateFormat(CreateDateTime(FORM.year, FORM.month, FORM.day,
      FORM.hour, FORM.minute, FORM.second))#
  <LI>Built with CreateODBCDate: #CreateODBCDate(yourDate)#
  <LI>Built with CreateODBCDateTime: #CreateODBCDateTime(yourDate)#
</UL>

<P>The same value can be formatted with dateFormat:
<UL>
  <LI>Built with CreateDate: #DateFormat(CreateDate
    (FORM.year, FORM.month, FORM.day), "mmm-dd-yyyy")#
  <LI>Built with CreateDateTime: #DateFormat(CreateDateTime
    (FORM.year, FORM.month, FORM.day, FORM.hour, FORM.minute,
      FORM.second))#
  <LI>Built with CreateODBCDate:
    #DateFormat(CreateODBCDate(yourDate), "mmmm d, yyyy")#
  <LI>Built with CreateODBCDateTime:
    #DateFormat(CreateODBCDateTime(yourDate), "d/m/yy")#
</UL>
</cfoutput>
</cfif>

<cfform action = "createODBCdatetime.cfm" method = "POST">
<P>Please enter the year, month and day in integer format for 
the date value you would like to view:
<PRE>
Year  <cfinput type = "Text" name = "year" value = "1998" 
  validate = "integer"
  required = "Yes">
Month  <cfinput type = "Text" name = "month" value = "6" RANGE = "1,12"
  message = "Please enter a month (1-12)" validate = "integer"
  required = "Yes">
Day  <cfinput type = "Text" name = "day" value = "8" RANGE = "1,31"
  message = "Please enter a day of the month (1-31)" 
  validate = "integer" required = "Yes">
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>