createODBCDateTime

Creates an ODBC date-time object.

createODBCDateTime(date) → returns date

Member Function Syntax

date.createODBCDateTime()

  1. CFDocs
  2. Functions
  3. Date and Time Functions
  4. createODBCDateTime
  5. CF
  6. Lucee
  7. BD
  8. 0 Issue
  9. Edit
See Also:   createDateTime   createODBCDate   createODBCTime

Argument Reference

date date
Required

Date or date/time object or string.

Compatibility

ColdFusion:

Member function is available in CF11+.

Lucee:

Member function is not available.

Examples
Sample code invoking the createODBCDateTime function

Uses the CreateODBCDateTime function to create an ODBC date-time object

<cfset Date = createDateTime(2012, 12, 12, 12, 12, 12)>
<cfset result = createODBCDateTime(Date)>
<cfoutput>#result#</cfoutput>

Expected Result: {ts '2012-12-12 12:12:12'}

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub