CFLib.org – Common Function Library Project

MySQLDT2TS(dt)

Last updated June 27, 2002
Download UDF

author

Mark Andrachek                                    Mark Andrachek

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

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>

Search CFLib.org


Latest Additions

Jose Diaz-Salcedo Jose Diaz-Salcedo added
cfRssFeed
2 day(s) ago

Raymond Compton Raymond Compton added
structBlend
23 day(s) ago

Duncan Duncan added
IsZIPUK
23 day(s) ago

Todd Sharp Todd Sharp added
getTagContentAll
29 day(s) ago

Gerald Guido Gerald Guido added
ListReturnDuplicat...
1 month(s) ago

Created by Raymond Camden / Design by Justin Johnson