CFLib.org – MySQLDT2TS

MySQLDT2TS(dt)

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 CF datetime into a MySQL timestamp.

Return Values:
Returns a string.

Example:

<CFOUTPUT>
The current time in MySQL timestamp:
#MySQLDT2TS(Now())#<BR>
<I>(Note - due to page caching, the time value will not change.)</I>
</CFOUTPUT>

Parameters:

Name	Description	Required
dt	Date object.	Yes

Full UDF Source:

	
	<cfscript>
/**
 * Converts a CF DateTime object into a MySQL timestamp.
 * 
 * @param dt      Date object. (Required)
 * @return Returns a string. 
 * @author Mark Andrachek (hallow@webmages.com) 
 * @version 1, June 27, 2002 
 */
function MySQLDT2TS(dt) {
    return Year(dt) & NumberFormat(Month(dt),'00') & NumberFormat(Day(dt),'00') & NumberFormat(Hour(dt),'00') & NumberFormat(Minute(dt),'00') & NumberFormat(Second(dt),'00');
}
</cfscript>