MySQLTS2DT(timestamp)
Last updated June 27, 2002
Version: 1 | Requires: ColdFusion 5 | Library: DatabaseLib
Description:
Converts the passed MySQL timestamp to a ColdFusion DateTime object.
Return Values:
Returns a date/time object.
Example:
<CFOUTPUT>
Timestamp = #TS#, CF date object = #MySQLTS2DT(TS)#
</CFOUTPUT>
Parameters:
| Name | Description | Required |
|---|---|---|
| timestamp | MySQL time stamp. | Yes |
Full UDF Source:
<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>
Search CFLib.org
Latest Additions
cfRssFeed
2 day(s) ago
structBlend
23 day(s) ago
IsZIPUK
23 day(s) ago
getTagContentAll
29 day(s) ago
ListReturnDuplicat...
1 month(s) ago