CFLib.org – MySQLTS2DT

MySQLTS2DT(timestamp)

Last updated June 27, 2002

Download UDF

author

Mark Andrachek
Send Email

Version: 1 | Requires: ColdFusion 5 | Library: DatabaseLib

Rated 0 time(s). Average Rating: 0

Description:
Converts the passed MySQL timestamp to a ColdFusion DateTime object.

Return Values:
Returns a date/time object.

Example:

view plain print about

<CFSET TS = "20011211145204">

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

<CFSET TS = "20011211145204">

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

Parameters:

Name	Description	Required
timestamp	MySQL time stamp.	Yes

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<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 (&#104;&#97;&#108;&#108;&#111;&#119;&#64;&#119;&#101;&#98;&#109;&#97;&#103;&#101;&#115;&#46;&#99;&#111;&#109;) 
 * @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>
		<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>