将一个MYSQL的时间戳转换为CF对应的时间对象 

<cfscript>
/**
 * Converts a MySQL timestamp to a CF DateTime object.
 *
 * @param timestamp   MySQL time stamp. (Required)
 * @return Returns a date/time object.
 * @author Mark Andrachek (hallow@webmages.com)
 * @version 1, June 27, 2002
 */
function MySQLTS2DT(timestamp) {
 return CreateDateTime(Left(timestamp,4),Mid(timestamp,5,2),Mid(timestamp,7,2),Mid(timestamp,9,2),Mid(timestamp,11,2),Mid(timestamp,13,2));
}
</cfscript>

<CFSET TS = "20011211145204">

<CFOUTPUT>
Timestamp = #TS#, CF date object = #MySQLTS2DT(TS)#
</CFOUTPUT>