CreateODBCDateTime() - create an ODBC date time object
CreateODBCDateTime.cfm
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>CreateODBCDateTime function example: how to create an ODBC date time object</title>
</head>
<body>
<h2 style="color:hotpink">CreateODBCDateTime Function Example</h2>
<cfset MyDateTime="10-Feb-2008 03:06:09">
<cfset MyAnotherDateTime="5-Dec-2007 00:01:01">
<cfset MyODBCDateTime=CreateODBCDateTime(MyDateTime)>
<cfset MyAnotherODBCDateTime=CreateODBCDateTime(MyAnotherDateTime)>
<cfoutput>
<b>
MyDateTime: #MyDateTime#
<br />
MyODBCDateTime: #MyODBCDateTime#
<br /><br />
MyAnotherDateTime: #myAnotherDateTime#
<br />
MyAnotherODBCDateTime: #myAnotherODBCDateTime#
</b>
</cfoutput>
</body>
</html>
- CreateDate() - create a date object
- CreateDateTime() - create a date time object
- CreateTimeSpan() - create a time span
- DateAdd() - add year, quarter, month, week, day, hour, minute, second to a date
- MonthAsString() - get the month name from a month number
- Quarter() - get quarter number from a date object